format numbers with no decimals Excel 2003

  • Thread starter 3 digit nubmers with no decimals
  • Start date
3

3 digit nubmers with no decimals

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.
 
F

Frank Kabel

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

RE: format numbers with no decimals Exc

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.
 
M

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.
 
Top