Under Tools Format Cells there is a "Time" format like the one you require.
If you want to format the cells as text with a formula you can use:
"=TEXT(A1,"hh:mm:ss")"
Hope this helps
Ian
--
Work performed in the spirit of service is worship...Baha''i Writings
"Browner" wrote:
I have a series of values(expressed in time format 00:00:00) but for
some reason some only appear as 00:00, which is fine but i want to just
add the preceding zeros to the existing values. For example if i had the
following values:
01:00:00
01:00
02:00
but i wanted it to look like:
01:00:00
00:01:00
00:02:00
How could i do that using a formula? Thanks,
--
Browner
------------------------------------------------------------------------
Browner's Profile: http://www.excelforum.com/member.php...o&userid=33657
View this thread: http://www.excelforum.com/showthread...hreadid=553519