Hi,
You could try to manage this with Time format.
First make cell where you will enter "012099" as Text formatted, just to keep leading "0".
Then just use formula like
Formula:
=LEFT(A1;2)&":"&MID(A1;3;2)&","&RIGHT(A1;2)
Hi,
You could try to manage this with Time format.
First make cell where you will enter "012099" as Text formatted, just to keep leading "0".
Then just use formula like
Formula:
=LEFT(A1;2)&":"&MID(A1;3;2)&","&RIGHT(A1;2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks