Yes it will look right,

but if the data is time
dont you want this to be
treated as HH:MM:SS.ss

A2= 12345678 format how you like
B2 =
=TIME(INT(A2/1000000),INT(MOD(A2,1000000)/10000),INT(MOD(A2,10000)/100))

And some extra bit to give you thousandths of a second on the end,
trying to get the units right

Steve


On Wed, 31 Jan 2007 15:01:01 -0000, phillr
wrote:

think i got it! :D

##":"##":"##":"##

seems to be working fine. don't know much about custom formatting, so
don't
know if there's any faux pas or 'inefficient' coding or what not, so feel
free to comment on it :D