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: 34
Joined: Mon Jun 09, 2008 8:26 am
Location: Baton Rouge, LA
Martin Colony History: 07/3pair 08/10pair 09/14pair 10/17pair 11/18pair 12/21pair 13/18pair 14/20pair 15/13pair 16/7pair. Landlord for 10yrs. Colony has shrunk the last two yrs.

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: 3453
Joined: Thu May 24, 2007 1:57 pm
Location: Missouri/Licking
Martin Colony History: Colony started - 2007 with one pair
As of 2018 - 84 cavities offered, max # of pairs hosted - 82.

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."
2016 - 82 pair
2015 - 76 pair
2014 - 75 pair
2013 - 75 pair
2012-72 pair

Return to “Purple Martin Forum”

Who is online

Users browsing this forum: -=DKC=-, 20stacky02, Dave Reynolds and 16 guests