Forum Discussion

Wantj43's avatar
Wantj43
Copper Contributor
Jun 13, 2022
Solved

Reformatting from number to text

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

excel
  • mtarler's avatar
    mtarler
    Jun 13, 2022
    Try =TEXT(--A1,"00") where A1 is the cell/range with numerical text you want to convert
  • mtarler's avatar
    mtarler
    Silver Contributor
    Jun 13, 2022
    Try =TEXT(--A1,"00") where A1 is the cell/range with numerical text you want to convert

Resources