Showing trailing zeros in a cell

bearcub

Well-known Member
Joined
May 18, 2005
Messages
625
Office Version
  1. 365
  2. 2013
  3. 2010
  4. 2007
Platform
  1. Windows
I have a cell formatted as general. I type in 7100, for example, and expect to see "7100". Instead, the formula bar and the cell display "71" which is not "7100". The cell customer formatting is "#,##0".

It looks like my entry has bee divided by 100. If I type in "710000" I see "7100". I don't know where in my computer setting I need to fix. Does anyone know how to fix this?

The other day I became aware of the when I had decimal numbers. The trailing zero in the decimal is missing in the formula bar even though I had just entered a trailing zero (80.4 to 80.40, doe example).

Or, I show 84 in the formula bar and then manually add 2 zeros to show 84.00 in the formula bar.

After pressing enter the zeros disappear from the formula bar but if I have 2 decimal formatting the zeros will display in the cell, not the formula bar.

What setting do I have to adjust on my computer
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

bearcub

Well-known Member
Joined
May 18, 2005
Messages
625
Office Version
  1. 365
  2. 2013
  3. 2010
  4. 2007
Platform
  1. Windows
I forgot to mention that if I format the cell as text, type in the numbers then convert the cell to number the zeros will show.

Really strange
 

bearcub

Well-known Member
Joined
May 18, 2005
Messages
625
Office Version
  1. 365
  2. 2013
  3. 2010
  4. 2007
Platform
  1. Windows
I think I found the issue. I remember go into the backstage and went to Advanced on the editing options. I had Automattically inset a decimal point set to 2. I moved it back to zero and it seems okay now. Maybe that was the issue?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,657
Messages
5,573,445
Members
412,529
Latest member
cTatch
Top