Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I disable the date & time functions?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I disable the date & time functions? | Excel Worksheet Functions | |||
Disable Date Recognition | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
simple date and time functions | Excel Discussion (Misc queries) | |||
Disable Date Recognition | Excel Discussion (Misc queries) |