If leading zeros appear in the cell, but not the formula bar, then they
result from formatting. They ae not actually in the data.

If you require them in the formula bar (not a normal requirement) precede
the value with an apostrophe (single quote).
--
Gary's Student - gsnu200798


"scottdog129" wrote:

I have a worksheet and I need to preserve the zeros in front of numbers in
the formula bar, but I cant seem to get them to show up. How do I do this?
They are in the cell, but not the formula bar?

TIA

Scott T.