Forum Discussion

Anthony Stroude's avatar
Anthony Stroude
Copper Contributor
Oct 26, 2018
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.

excel

2 Replies

  • Smitty Smith's avatar
    Smitty Smith
    Former Employee
    Oct 26, 2018
    How about: ="00'"&A1 Or type the format you want in the first cell, then go to Data > Flash Fill.

Resources