Numbers displayed in the 100th decimal instead on 1,000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get my numbers to be desplayed in decimal format instead on
number. How do I do that?

For example: 14,000 to be desplayed as 14.0
or 125,500 to be displayed as 125.5
 
Never mind the 0.0 is not working. I am going to stick with the first one.
the 0,.# It works the best
 
This works too. I can now see the 0's on large numbers. at first it was
showing 1. and leaving off the 0 now it shows the complete 1.0

Thanks.
 
Sorry I got that kinda backwards and plain old fashioned wrong... Try this
custom format...

0.0,
 
Format the cell with the the custom format (Format -> Format Cell -> Number
-> Custom)

0,.#
 
If you are saying there is confusion between commas and full stop signs for
decimal points and thousands separators, look at your Windows Regional
Options.
Or is your number actually being shown correctly in the formula box, & just
needing to be formatted differently?
 
Back
Top