View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.