dramajuana

find "option to prevent Excel changing 1-2-3 to a date" and agree with the
suggestion.

--
Vince


"dramajuana" wrote:

Okay, is there any way I can disable formulas? I don't need them, and it's
frustrating when I use a dash as a placeholder (-) and it starts to make a
formula.

I'm making a spreadsheet that has appointment times on it and such. Another
thing it does is when I put that an appt is from 8-11, it decides that I mean
August 11. I changed the property of that column to time, but then if I put
9-1, it thinks I mean 1 am. Is there any way to make it not care about am or
pm, because I think I can figure it out without putting 13 for 1 pm.