Thread
:
Automatic Date In Excel
View Single Post
#
2
Peo Sjoblom
Posts: n/a
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.
Reply With Quote