And I thought formatting only changed the appearance, not the value
<bg

I think you meant that 2 would appear as 0002 when formatted that way.

Pete

Gary''s Student wrote:

you can use formatting
for example if you want
2 to appear as
0001

then format the cell as custom 0000
--
Gary's Student


"nobby" wrote:

How do I show Leading Zero's in Excel