Changing columns with general format in Excel from "1" to "001"

Experts,

Column A on my report is displaying as "001" but appears to be "1".  I want to use this column for a vlookup so I want to change all the values so that they are three characters zero filled.

How can I do this?
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Are they integers? If so, use TEXT(A1,"000").

If they are not numeric, then you can use RIGHT("000" & A1,3).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.