Thanks Jim - that makes sense. But what is RTFM please?
On 5/18/2016 11: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 <a.b...@mindspring.com> 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: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org