0-60 minute time format

D

Drew Remsen

I have a data string of numbers between 0-59 that are part of a time
signal collected by an instrument that correspond to the minute of the
time signal. For values between 0-9 I would like them instead to read
like 00-09. The rest of the digits are already in a two digit format so
they are fine.How can I accomplish this?
Andrew
 
K

Karthik

-------------------------------------------------------------------------
Format the cells by
Format > Cells... > Custom>

In the "Type:" field enter the following format and this should do
the trick

"00:"00

and click OK

Thanks
KB
-------------------------------------------------------------------------
 
Top