| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with date - can't enter 15th!
The autocorrect works. And it was for the number 15! It had it to be replaced
with 16. How would that get in there?? Thanks! "Glenn" wrote: Look at Tool / AutoCorrect Options to see if there is an entry that accounts for what you are seeing. Meenie wrote: I tried the apostrophe and it still changed from 1/15 to 1/16, I tried changing the format to "text" and it still changed!! this is too weird! "Dave Peterson" wrote: 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 |
| 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
