Hi to all,


I have needed advice or maybe a formula for cell or columns formatting,
Namely I have cell with numbers and they could be cells for time (hh:mm:ss)


For example
If I have column with numbers:

Example:
Time
84233
112535
5231
5623
65236
103523
163526
225324

The results that I would like to have a
Time
084233
112535
005231
005623
065236
103523
163526
225324

OR

Time
08:42:33
11:25:35
00:52:31
00:56:23
06:52:36
10:35:23
16:35:26
22:53:24

The same column, but formatted like time

I hope that you are going to help me, giving me advice how can I do this or
maybe the problem can be solved by formula.

Thank you.