trailing 0's when formating is for no decimals

D

DaveM

I have formatted the cell as number with thousand seperator and no decimals.
Yet to get 90,000 in a formula I have to put in 9000000. If I don't add the
zero's, Excel uses 2 decimals and rounds the number.
 

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

Excel does not accept text format! 0
Mail Merge - displaying a conditional number of decimals 5
Fraction to Decimal 2
Converting decimal degrees to degrees, minutes & seconds 2
Using project as a resource tracker 0
Sum Function has small remainder 2
excel 2003 zero as last decimal again 1
excel 2003 zero as last decimal 5

Top