How do I get 18 numbers to display in a column and not round out
 

I need a column to display 18 numbers and currently it is rounding the last
three with zeros. I am using Microsoft 2003

How do I get 18 numbers to display in a column and not round out
 

How many digits in the numbers
More than 15? Then you will need to type then as text and will not be able
to do math on them
Either
a) when typing, precede the entry with a single quote (will not show in cell
or printout
b) before typing, format cells as Text
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

"whamm24" wrote in message
...
I need a column to display 18 numbers and currently it is rounding the
last
three with zeros. I am using Microsoft 2003