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.
 
Not sure how this works but it is working GREAT!!!!
Thank you very much!
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to hide formula 5
I am not real sure what type formula to use 1
I want to enter a figure &excel makes last two digits decimals 4
Decimal places in a calculated Text Box 9
Remove decimal but keep entire number 5
Decimal point in bar chart and similar 1
Fixed Decimals in Excel 2007 4
custom number format 3

Back
Top