PERFECT, Jim!

Thanks for your quick and accurate response!

Al
"JimMay" wrote in message
news:OXXkg.41425$fG3.4132@dukeread09...
In B1 enter:

=TEXT(LEFT(A1,LEN(A1)-2),"00")&":"&(RIGHT(A1,2))

And copy down.


"Al Gillis" wrote in message
:

TIA for your help or reference links...

I've got a bunch of numbers (formatted as "general") I want to appear
more
as time of day (no math needs to be done on these number)

For example, if my entries a
603
1851
720
1643
I want the resulting formated numbers to appear as:
06:03
18:51
07:20
16:43
(showing leading zeros where appropriate and colons)


Because these are just numbers I usually get results than look like dates
from early in the previous century!

Thanks!

Al