Martinwatch spreadsheet date format question.

Welcome to the internet's gathering place for Purple Martin enthusiasts

Martinwatch spreadsheet date format question.

Postby Guest » Sun Jun 22, 2008 12:24 pm

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?


Postby Guest » Sun Jun 22, 2008 6:06 pm


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:

User avatar
Posts: 24
Joined: Mon Jun 09, 2008 8:26 am
Location: Baton Rouge, LA

dates on spread sheet

Postby gussiemike » Sun Jun 22, 2008 6:12 pm

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.


Postby Guest » Sun Jun 22, 2008 7:26 pm

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.


Postby Guest » Sun Jun 22, 2008 7:34 pm


User avatar
Posts: 3262
Joined: Thu May 24, 2007 1:57 pm
Location: Missouri/Licking

Postby KathyF » Mon Jun 23, 2008 1:43 pm

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.... :lol: :lol:

What does "1/2N" mean, for example?
"Sometimes", said Pooh, "the smallest things take up the most room in your heart."
2013 - 75 pair
2012-72 pair

Return to “Purple Martin Forum”

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest