Forum Discussion
Shaun Langille
Jul 05, 2023Copper Contributor
number formatting
Hi I am currently having issues with formatting a large number of numbers. In my workbook, I have a column containing numbers with dashes "-", and the numbers also have preceding "0's" for example: 001-1111-11111. I am trying to figure out away to remove the dashes, while retaining the full number including the preceding "0". for example 001111111111
I know that I can use the replace function to remove the dashes, however that also removes the preceding 0's, I also know that I can add and apostrophe ' to the start of the number and manually remove the dashes, however, this would require manual edits to each and every cell in the column.. I am hoping to find away to do the whole column at once...
Thanks for any suggestions.
3 Replies
- Shaun LangilleCopper ContributorHoly crap....lol, that worked perfectly...thanks so much!
- OliverScheurichGold Contributor
- Shaun LangilleCopper ContributorHoly crap....lol, that worked perfectly...thanks so much!