Displaying leading zeros

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
 
J

J.E. McGimpsey

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)
 
Top