Excel Format Question -- CC:SS treated as time HH:mm

1

1clncc

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?
 
G

Guest

Another approach to avoid typing in the colons:)) is to use >Format>Custom
then "0"#":"###, whcih would produce a leading zero if not needed skip it.
you would enter 1225 and screen would show 01:225
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

format time problem 5
Time Conversion issue 5
Adding Time Values in HH:MM Format 3
changing the format for the time shen entered as HHMM to HH:MM 2
Summing cells defined as Time hh:mm 4
Opening a csv file with US date format on a Australian PC 2
htm date & time format 11
Time format in GridView 5

Top