I need to add a 0 to many rows of data in a excel table.
I currently have this per row: ABC-00-101
I need to change this to ABC-00-0101
I already have ABC-00-1000
The reason for the change is so I can sort the data in the correct numerical order.
Any ideas?
Thanks
Paul
Bookmarks