How to get the leading zero's added in a document
"sam" wrote in message
...
hi
i have a document which is added with leading Zero's in some of the
columns
for eg., in the ZIPCODE column my value is 09281 but in the display i am
getting it
as 9281. But i want it with the original value. Can anyone tell me how to
get the
original values
Sam,
Most people don't use zip codes in calculations, so in Excel they might as
well be text that just look like numbers.
So...
Format/Cells/Text
or
Format/Cells/Custom/00000
HTHelps
Beege
|