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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count unique distinct values that meet multiple criteria 1
remove leading zeros on a text field 14
Access Tidy up phone numbers 0
Custom format leading zero 5
How to combine cells into one 3
Importing Text Files Into Access 1
Split text field in VBA 16
Windows 11 Windows 11 update 1

Back
Top