7 replies
by georgem5 Accepted solution
by dogknees Accepted solution
by notaballoon Accepted solution
by locolobo Accepted solution
by brian_meahan - techtoolbox.com Accepted solution
If every cell in the column is supposed to have a leading zero then you can do something along the lines of going to an empty column and writing a simple concatenate function "=CONCATENATE("0",B5)" where B5 is whatever cell has the original data. Then copy this function down the column to update all the rows. Copy that column and in another empty column by doing a paste special and select values. Then when you confirm it is all correct you can copy this and do a paste special over the original column (again selecting values). Delete the two extra columns you just created and voila. Do make sure the column is set to text before pasting back or you will just loose the new Zero again :-) .
If you have to do it on selected values you can use a similar approach and do an if function with a nested find/replace. That will depend on being able to identify those cases which only need a leading 0 based on the other cells in that row.
by georgem5 Accepted solution
by brian_meahan - techtoolbox.com Accepted solution
This discussion is closed to new replies.
Trending Software posts
Sort by Trending