Preserve leading zeros

[George Meagher]

Is there a way to preserve leading zeros in a number without treating it
as text?
For example when I enter the census track 0811.01 it comes out as 811.01

--
George A. Meagher, Compliance Officer
Sikorsky Financial Credit Union
1000 Oronoque Lane, Stratford CT 06614
Phone: (203) 377-2252 x7418; Fax: (203) 378-4787
E-Mail (e-mail address removed)

 

[Mariah]

If you put ' (an apostrophe) in front of the entry it will
preserve the zero.

 

[Helper dude]

Format the cells under number tab as custom and
type "0000.00" this is easier than adding an apostrophe on
every entry

 

[Norman Harker]

Hi George!

Unless you're going to do calculations on the cell, pre-format as
text.

Or enter a ' or " or ^ before entering the number. ' left aligns, "
right aligns and ^ centres

If you want to use it as a number and it's all four digits before the
point use custom format 0000.00


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Guest]

Thanks for the info, it seems so simple, especially since I use the customer formating for many other uses, but sometimes it the little things that you forget.