How can I turn off rounding for numbers???

J

Julie

Excel 2003: I've got a column of cells. I highlight the entire column, do a format / cells / number then I choose 0 decimal places

I have a list of serial numbers that I want to input, and then "fill down"... because they're all in sequence. However, when I input. They are 14 digits long. Every time I input a 14-digit number, Excel forces it to round up to the 5th number from the right. How can I get it to stop doing this?
 
F

Frank Kabel

Hi
Excel should not round in this case. Maybe it shows the
number in the scientific notation.
Try the folowing custom format:
00000000000000
-----Original Message-----
Excel 2003: I've got a column of cells. I highlight the
Click to expand...
entire column, do a format / cells / number then I choose
0 decimal places.
I have a list of serial numbers that I want to input, and
Click to expand...
then "fill down"... because they're all in sequence.
However, when I input. They are 14 digits long. Every
time I input a 14-digit number, Excel forces it to round
up to the 5th number from the right. How can I get it to
stop doing this?
 
Top