Hi!

Be advised that this method only changes the appearance of
the numbers and does not convert them to true times.

Using this method the cell looks like 12:34 but the actual
underlying value is 1234 (one thousand two hundred thirty-
four)

Biff

-----Original Message-----
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 news:55FB6EF0-E601-4E5E-B631-
...
.