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

Similar Threads

Excel duplicating files 1
Insert row(s) with vba 3
reverse pivot table-like data 1
Find and Copy 2
To find rate of each item from item.xls and to copy price.xls 7
VLOOKUP isn't working properly in Excel on Mac 1
How do I put numbers in order into each cell of a worksheet? 2
I need Excel to make "1" into "001" 6

Top