Custom format a number list that contains a hyphen
In my data the account field contains two sets of data formats. An 6 digit and 10 digit.
Example:
I would like to format the list to the 10 digit format using 00-000000-00 as the format.
Account # 4444-22 4444-20 22-666666-22 22-666666-20
How do I format the 6 digit numbers that contain a hyphen into a 10 digit format 00-000000-00 with leading zeros.
Last edited by toxicatom; 12-22-2011 at 05:00 PM.
toxicatom,
Could use a helper column with this formula copied down as necessary, and then hide the original:
=TEXT(--SUBSTITUTE(A1,"-",""),"00-000000-00")
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
That will work, thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks