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??

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??

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

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??

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

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

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

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

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