MASK TO TEXT FIELD

  • Thread starter Thread starter Hendrix10
  • Start date Start date
H

Hendrix10

I have a custom field that has leading 0's (ie 002-458). I would like
to change that custom field to a text field without losing the 0's (ie
002458). Is that possible?
 
Try this in a helper column:

=TEXT(A1,"000000")

and copy down as required.

Hope this helps.

Pete
 
Back
Top