If you have more than 4 digits, perhaps you wish to show seconds too, simply
use

00":"00":"00

Now 123456 will show as 12:34:56

You can continue this format for as many digits as you need, just keep
repeating the ":"00
"MikeY" wrote:

Format the concerned cells as 0":"00
123 -- 1:23
1234 -- 12:34

However, please note that 5 or more digits number would show as below;

1234567 -- 12345:67

--
Mike

"Dan W." wrote in message ...