Forum Discussion
Solved
I want to add 00' before the contents of a number of cells
I have a column which has content in the format 25'42 (represents time) which I want to convert to 00'25'42. What is the quickest way to amend the entire column? Not conversant with macros.
Great thanks. Got it.
How about: ="00'"&A1
Or type the format you want in the first cell, then go to Data > Flash Fill.
Great thanks. Got it.