Time interpreted as range.

[George Wilson]

I have a spreadsheet that I am trying to enter a time in
the format of 12:30 and excel keeps changing it to a
range. I checked the cell format and it appears to be
correct. On another sheet in the same workbook this
problem does not exist. What might cause this behavior?
TIA
George

 

[John P]

George,

I think you must be typing an I instead of a 1 possibly?

John

 

[George Wilson]

No, it does not matter what number is being typed.
George

 

[Dave Peterson]

Are you starting with an equal sign?

=12:30
instead of
12:30
???

 

[George Wilson]

No, but Excel is inserting one for me like it thinks I
want it to be a formula.
George

 

[Dave Peterson]

Try turning off:

tools|options|transition tab|transition formula entry

If you're a "normal" excel user (and there aren't many normal people who use xl
<vbg>), you'd probably be better served by turning off all those Lotus 123
transitions.

(I have and think that I'm a better person for doing so. <vvbg>)

 

[George Wilson]

That fixed it, thank you very much...
George

-----Original Message-----
Try turning off:

tools|options|transition tab|transition formula entry

If you're a "normal" excel user (and there aren't many normal people who use xl
<vbg>), you'd probably be better served by turning off all those Lotus 123
transitions.

(I have and think that I'm a better person for doing so.