LEADING ZEROS IN EXCEL

  bartonside 14:52 03 Nov 2010
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 2010

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.

Elsewhere on IDG sites

Intel Coffee Lake release date and specifications

12 Amazing British Craft Beer Label Designs

watchOS 4 review

Les meilleurs navigateurs internet 2017