Reformatting from number to text

[Wantj43]

The data was entered as numerical however should be in text form. How can “5” be converted to “05” if the numerical field is converted to text?

Thank you 

Joe

[#2 · Accepted solution]

Try =TEXT(--A1,"00") where A1 is the cell/range with numerical text you want to convert

[#3]

Thank you! Works great.
Joe