Thread: Excel Format Question -- CC:SS treated as time HH:mm
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Excel Format Question -- CC:SS treated as time HH:mm
Format the cells as text *before* you enter the data.
--
David Biddulph

"1clncc" wrote in message
oups.com...
I have in one column 01:01; ... 25:99 etc referring to Bible
Chapter : Section's .
Excel is treating the column as Time HH:mm; converting some of the
cells:

a) some - - HH:mm:00
b) some - - 0.YYYYYYY

When I tried to convert the CC:SS into text, all becoming 0.YYYYYYY
etc.

Wondering
how can I keep the CC:SS format without being mixed with HH:mm?



Reply With QuoteReply With Quote