Displaying leading zeros

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Hi,

I'm currently working on a report in which I'm importing time values
into a excel spreadsheet. The time values I'm importing are displayed
as h:mm:ss or :mm:ss. However for my formulas to work all of the
times must be displayed as h:mm:ss. I know that I could go in and
manually adjust each cell, but it is a lengthy report. So my question
is, does anyone know how to format the cells to convert data imported
as :mm:ss to h:mm:ss so that the leading zeros are displayed? For
example, taking :34:27 and then show it as 00:34:37 when imported?
I've tried formating the cells as h:mm:ss prior to importing the data,
however that didn't work.

Thanks,
Brian
 
Changing the format will not change the value stored in the cell and
used in formulas.

Perhaps you could use something like:

=RIGHT("00" & A1, 8)
 
Back
Top