| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with date - can't enter 15th!
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?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date if before or after 15th of month | Excel Worksheet Functions | |||
| date formula returns the 15th or the end of month | Excel Worksheet Functions | |||
| If date in column A is less than 15th of month can I display next. | Excel Discussion (Misc queries) | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
Threaded Mode
