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?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with date - can't enter 15th!
Hi,
What is the format that you are actually applying to the cell. In other words when you are on a formatted cell and choose Format, Cell, Custom what is the code in the Type box? -- If this helps, please click the Yes button Cheers, Shane Devenshire "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?? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with date - can't enter 15th!
I went to "format" picked "date" and chose the example that showed "3/14"
I didn't pick "custom" or a format that isn't a date. "Shane Devenshire" wrote: Hi, What is the format that you are actually applying to the cell. In other words when you are on a formatted cell and choose Format, Cell, Custom what is the code in the Type box? -- If this helps, please click the Yes button Cheers, Shane Devenshire "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?? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with date - can't enter 15th!
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with date - can't enter 15th!
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with date - can't enter 15th!
Hi,
Tools|Autocorrect options enter 1/15 on the left hand side and if you see 1/16 in the replace with box the delete the entry. Mike "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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with date - can't enter 15th!
I think it's the autocorrect, too.
But I misread your message. I thought you wanted to enter 1/15th, not a real date. Don't use the text or apostrophe stuff. 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 -- Dave Peterson |
#9
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 |
Reply |
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) |