I have a column of numbers that I need to edit. I need to insert a "-" after every 3rd character. Not all of the cells have the same # of characters.
ex.
9896051
9927091
11763321
13182041
needs to be
989-605-1
992-709-1
117-633-21
131-820-41
I have a column of numbers that I need to edit. I need to insert a "-" after every 3rd character. Not all of the cells have the same # of characters.
ex.
9896051
9927091
11763321
13182041
needs to be
989-605-1
992-709-1
117-633-21
131-820-41
Last edited by Onestopfanshop; 10-05-2010 at 09:20 AM.
Hello OSFS
does it have to be formatted in that way or can it be
9-896-051
9-927-091
11-763-321
13-182-041
If the above is ok then FORMATT, CELLS, CUSTOM, AND TYPE IN ###-###-###
Let me know if this is OK please
Regards
Peter
OSFS
Please have a look at this, the numbers now have the dashes but are still a true number(not text), just the formatting has been changed.
Regards
Peter
Sorry I've just done the exact oposite, I'm not sure you can format the number from the left, can there be formulas involved, how many numbers involved, if need be can there be work colmns (hidden if you like.
May be able to format if the numbers are stored as text as it works left to right
Regards
Peter
Please have a look, this is using a work column, but could be combined if it is a problem.
Regards
Peter
The numbers are no longer stored as numbers.
Thanks. Works great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks