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
