Automatic Date In Excel

T

The Met

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.
 
P

Peo Sjoblom

Use text format or precede entry with an apostrophe '

--
Regards,

Peo Sjoblom

(No private emails please)
 
R

ratt

Right Click On A Cell You Want The Date To Show Up On...choose Forma
Cell, Under The Tab Data, Choose Date, A Selection Of Date Types Wil
Be Provided For You To Select The Format You Desire Or You Can Creat
One For Yourself..pres Ok And The Date Should Appear In The Cel
Selected...the Only Problem After That May Be The Cell Size And Th
Size Of The Data Info Inside Of It..if Too Small You Will Get #####.
Good Luc
 
B

Bryan Hessey

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
 
Top