Spreadsheet quandary

[Solarion]

I go to spreadsheet and type "24:00" then hit enter.

Suddenly "24:00:00"

or type "00:00" turns into "0:00"

I do not like this.

What do?

 

[themba990]

Ctrl-1, change format to text. do this before you type
or
type "'24:00"

 

[Arthur]

http://www.databison.com/custom-format-in-excel-how-to-format-date-and-time/
http://www.excel-easy.com/examples/custom-number-format.html#dates-times

<GN>
Btw, it has an A.
</GN>

 

[Solarion]

Thanks guys.