CARA AGAR ANGKA 0 TERBACA DI EXCEL

When using Excel, sometimes we encounter a situation where the zero (0) digits at the beginning of a number disappear. This can be a problem when we need to maintain the integrity of our data. Thankfully, there are several ways to handle this situation.

Method 1: Format Cells

CARA AGAR ANGKA 0 TERBACA DI EXCEL

One way to ensure that the zero digits do not disappear is to format the cells containing the data. Here’s how to do it:

  1. Select the cells you want to format.
  2. Right-click on the selected cells and choose “Format Cells.”
  3. In the Number tab, select “Custom.”
  4. In the Type field, enter at least one zero (0) followed by the desired number of digits. For example, to display four digits, enter “0000.”
  5. Click “OK.”

Now, when you enter a number that starts with zero, the zero digit will remain visible.

Method 2: Add an Apostrophe

add an apostrophe example

Another way to prevent the zero digits from disappearing is to add an apostrophe before the number. Here’s how:

  1. Type an apostrophe (‘) in the cell where you want to enter the number.
  2. Enter the number you want to display, including any zero digits at the beginning.

The apostrophe tells Excel to treat the value as text, preserving the leading zero digits.

FAQ

Q: Can I use these methods with formulas?

A: Yes, you can format cells containing formulas or apply the apostrophe to values generated by formulas. Just make sure to include any necessary parentheses or operators within the formula.

Baca Juga :  CARA BUAT RUMUS EXCELL SEKALI INPUT KELUAR DATA

Q: Do these methods affect the underlying value of the cell?

A: No, these methods only affect the display of the cell. The underlying value remains the same. If you need to use the value in a calculation or function, Excel will use the full value, including any zero digits.

If you want to see these methods in action, check out this youtube video: