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 ...