LEADING ZEROS IN EXCEL

  bartonside 14:52 03 Nov 10
Locked

I have been trying to find a way to create numbers reading 01, 02, 03 and so on in Excel but the cells number format box doesn't contain this option. I did achieve it a while ago but cannot remember how I did it. Any ideas?

  VoG II 14:59 03 Nov 10

In the cells format dialog click Custom then in the box type 00 and click OK.

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017