format number rounds off

[Tdiana]

I am trying to formate a row of numbers in excel. The numbers that I am
trying to type in each column consists of four digets as in 2760 but
after I type in this number it only showes 28. Every number rounds to
the next thousand. I keep checking the format for number with no
decimals and I get this every time. How do I make it show the four
typed digets?

 

[Gord Dibben]

Tdiana

My guess is if you look down on the bottom right of your status bar you will
see the letters FIX or if you go to Tools>Options>Edit you will find "Fixed
Decimal Places" with a checkmark.

Excel is automatically placing two decimal points in your entry. If you were
to set the format to show decimal places you would see 27.60

Uncheck the box.

Gord Dibben Excel MVP

"This message was answered by a volunteer in the Microsoft public
newsgroups. To connect to the public newsgroups set your news server
to... msnews.microsoft.com"