=--TEXT(A2,"00\:00") and format as time.
--
David Biddulph

"quinto via OfficeKB.com" <u35571@uwe wrote in message
news:80d6ceba688c6@uwe...
I have a column that has numbers as followed 630, 530, 1030 represting
times,
I need to convert these numbers to 6:30, 5:30, 10:30 and so on.

Thanks
Quinto

--
Message posted via http://www.officekb.com