ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I disable the date & time functions? (https://www.excelbanter.com/excel-worksheet-functions/220476-how-do-i-disable-date-time-functions.html)

brynmawrstudent12

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?

Roger Govier[_3_]

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?




All times are GMT +1. The time now is 10:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com