There are two possibilities as far as I can see:
1. The Cell is Formatted as a date field M/16
If you enter 5/18 it will displays 5/16
2. There is a AutoCorrect Option set for this value
Don't ask me why.
On 19/05/16 4:50 AM, James Plante wrote:
The problem IS the format. That cell is formatted to display mm/yy if it
appears as you said. You entered 5/18, meaning May 18. The cell is formatted to
display the month and the two-digit year, therefore it displays the month as 5
and the year (2016) as 16, since if you don’t enter a year, it presumes the
current year. That’s how it got to 5/16. The format is not set to display the
day of the month, so it doesn’t. Try entering 12/24. It’ll come out 12/16
unless you change the format.
If you can, as you assert, “change the format,” then change it to mm/dd instead
of mm/yy. If you don’t know how to do that, go RTFM, and come back if you need
more help.(Hint: Right-click the cell, choose Format Cells… then choose Date,
and either pick a pre-made format from the list, or format manually.) For
special formats, you’ll need to RTFM to find out the formatting codes.
Jim Plante
On May 18, 2016, at 1:29 PM, Ron Patterson <[email protected]> wrote:
The problem is not the format. I can change that. The problem is the numbers
that are entered are not the numbers I type in. 5/18 is appearing as 5/16.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
