Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 150
  • Last Modified:

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?
0
morinia
Asked:
morinia
1 Solution
 
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now