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