Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I disable the date & time functions? brynmawrstudent12 Excel Worksheet Functions 1 February 11th 09 11:19 PM
Disable Date Recognition Saxman Excel Discussion (Misc queries) 0 September 27th 06 07:09 PM
Calculating days & time left from start date/time to end date/time marie Excel Worksheet Functions 7 December 7th 05 02:36 PM
simple date and time functions marquis de montrose Excel Discussion (Misc queries) 2 December 6th 05 11:13 PM
Disable Date Recognition Saxman Excel Discussion (Misc queries) 2 August 19th 05 05:36 AM


All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"