Martinwatch spreadsheet date format question.

Guest

Why is my martin watch spreadsheet using different date formats in each cell? It it a programming bug or operator error?Anybody else having this issue?

Am I filling this out right?

Guest · Posted: Sun Jun 22, 2008 6:06 pm Post subject:

WVM-

I just played with my form, and if I type in the number 6, as in June 6, I end up with 6/6/2008. But if I type in the word Jun instead of the numerical 6 it will result in something like you have, but I always get the year. If I double left click - even that will revert to 6/6/2008.
I didn't want to risk messin up any of my true dates, so I picked a nest check date that was way to the right to play around in, and then did not save the changes.
Like they say in Martinese: that's the way it is in my colony. Wink

gussiemike · Joined: 09 Jun 2008 Posts: 24 Location: Baton Rouge, LA

Hi,
It could be that all the cells are not formatted the same. You can click on a cell where you want to put a date, then go to format and select how you want the date to appear in the cell. There are several different ways it can be displayed, just pick one you like and select it. Each cell will have to be formatted the way you want it.

Guest · Posted: Sun Jun 22, 2008 7:26 pm Post subject:

The cell format is not able to be edited. I assume that it is protected. I did nothing to the spreadsheet as far as changing the cells, and I put the date in the same way everytime. If click on the cell it goes back to MM/DD/YY format, as soon as I hit enter it goes back to Day-month.

Guest · Posted: Sun Jun 22, 2008 7:34 pm Post subject:

BUMMER!!!!!!!!!!!

KathyF · Joined: 24 May 2007 Posts: 2968 Location: Missouri/Licking

Mr. WV -
I thought the dates are supposed to be listed in the white part - not in the purple heading. I probably need to go read the instructions again.... Laughing

What does "1/2N" mean, for example?