I'm using excel and i want to put 001, 002

G

Guest

Hiya!

I am using Excel and i want to have 001,002,003 etc as a code but whenever i
type this in it automatically changes to 1,2,3 how can i stop it from doing
this?
 
G

Gord Dibben

Alternative.

Format cells to Custom 000

Just enter 1 ,2. 3 to see 001, 002, 003

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top