View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Problem with date - can't enter 15th!

Either preformat the cell as Text, then do the data entry.

Or

Start your entry with an apostrophe:
'1/15



Meenie wrote:

I have excel 2003
I have a spreadsheet and on one worksheet I enter the date that documents
are turned in.
the cells are formatted to date and to show up like 1/10
Problem: I can't eneter 1/15! I can enter 1/14 and I can enter 1/16 but if I
enter 1/15, it changes to 1/16 as soon as I either hit enter or click into
another cell.
what's up with this??


--

Dave Peterson