format numbers with no decimals Excel 2003

[Guest]

I need to display invoice number eg: 145 but i can't seem to get the format
cells to work. It keeps rounding it off to a 1 or displays as 1.45. i just
upgraded to Excel 2003 my older verison woudl let me do this.

 

[Guest]

Hi
just use a format such as
0

 

[Guest]

The "0" will not work. it dispalys as a 1 not 145.

 

[Guest]

Hi
what value have you entered in the cell and what is the expected result for
this cell

 

[Guest]

I've put in the number 145 and it shows up as 1.45. I then go to format,
cell, general and it shows 1.45 in hte sample part. If I go to number and set
to 0 decimcal. and the number goes to a 1. If I go to special and put in 000
the number still shows a 1.

 

[Myrna Larson]

The problem is that the number isn't 145 (one hundred forty five) but 1.45, as
you see in the format dialog box.

Do you have Fixed Decimal turned on (Tools/Options/Edit)? If this is turned on
and set to 2 decimal places, when you type 145, Excel divides by 100 and puts
the number 1.45 in the cell. If this is the problem, turn this setting off.

But if I have a cell that contains the value 1.45, and I set the custom number
format 000, I see 001, not 1. So you seem to have a problem here, too.