date

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Hello
When I enter "1-Nov" cell changes to 11-Jan. How do I get the cell to stay
as 1-Nov.

Thanks
 
suggest format as d-mmm and use 11/1 as your entry or use text to do it your
way.
 
Hello
When I enter "1-Nov" cell changes to 11-Jan. How do I get the cell to stay
as 1-Nov.

Thanks
Click to expand...

I cannot reproduce that. Perhaps there is some underlying macro that is
changing "1-Nov" to the numeric value eleven (11). Or perhaps you mean
something else by <enter> than just typing in the value?

When I type 1-Nov into a blank cell, it changes into the Excel Date for
11/1/2004, just as it should.
--ron
 
Back
Top