Reformat numbers in table
2 views (last 30 days)
I have a table and in one column there is a row of subject numbers going from one digit up to three digits.
I would like to reformat them so they are like this i.e. 'Subject' at beginning and all number with 3 digits (1 and 2 digit numbers should have 00 and 0 at begining respectively to make 3 digits.)
Could someone advise how to do this?