View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default How do I disable the date & time functions?

Hi

Place a single quote ' in front of your entry.
It won't show in the cell, but it will force the value to be treated as
Text.

Still plenty of snow up at Brynmawr?
It has nearly all gone down at Abergavenny.

--
Regards
Roger Govier

"brynmawrstudent12" wrote in
message ...
I am trying to just put certain #'s in my chart in a column next to vocab
words. (It's for a noun class reference for studying). But, whenever I put
a
number and go to the next cell, it changes form a number to a date. I just
want the number, I don't want the function to go off. How do I disable it?