Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic Date In Excel
How would i be able to stop the date from automatically appearing.
Ie; I type 11 - 20 [which is precisely what i want] but then Excel changes it to Nov-2020, and 11/11/2020 in the function bar. How can i stop that happening? Thanks. |
#2
|
|||
|
|||
Use text format or precede entry with an apostrophe '
-- Regards, Peo Sjoblom (No private emails please) "The Met" <The wrote in message ... How would i be able to stop the date from automatically appearing. Ie; I type 11 - 20 [which is precisely what i want] but then Excel changes it to Nov-2020, and 11/11/2020 in the function bar. How can i stop that happening? Thanks. |
#3
|
|||
|
|||
Right Click On A Cell You Want The Date To Show Up On...choose Format Cell, Under The Tab Data, Choose Date, A Selection Of Date Types Will Be Provided For You To Select The Format You Desire Or You Can Create One For Yourself..pres Ok And The Date Should Appear In The Cell Selected...the Only Problem After That May Be The Cell Size And The Size Of The Data Info Inside Of It..if Too Small You Will Get #####. Good Luck -- ratt ------------------------------------------------------------------------ ratt's Profile: http://www.excelforum.com/member.php...o&userid=24318 View this thread: http://www.excelforum.com/showthread...hreadid=395614 |
#4
|
|||
|
|||
to retain what you type, put a ' first, as: '11 - 20 will show as 11 - 20 in the cell and will stop Excel from assuming either something in November or -9 ratt Wrote: Right Click On A Cell You Want The Date To Show Up On...choose Format Cell, Under The Tab Data, Choose Date, A Selection Of Date Types Will Be Provided For You To Select The Format You Desire Or You Can Create One For Yourself..pres Ok And The Date Should Appear In The Cell Selected...the Only Problem After That May Be The Cell Size And The Size Of The Data Info Inside Of It..if Too Small You Will Get #####. Good Luck -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=395614 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
excel formula counting date to date in 4 columns | Excel Worksheet Functions | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
In Excel 2003, entering date without slashes, the date is incorre. | Excel Discussion (Misc queries) | |||
Excel 2002 date formulas problem | Excel Worksheet Functions |