Martinwatch spreadsheet date format question.

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

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?

Image

Am I filling this out right?

Guest

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

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:

User avatar
gussiemike
Posts: 26
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

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

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.

Guest

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

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

User avatar
KathyF
Posts: 3383
Joined: Thu May 24, 2007 1:57 pm
Location: Missouri/Licking
Martin Colony History: Colony started - 2007 with one pair
As of 2016 - 84 cavities offered, max # of pairs hosted - 74.

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."
2015 - 76 pair
2014 - 75 pair
2013 - 75 pair
2012-72 pair
http://kathyfreeze.blogspot.com


Return to “Purple Martin Forum”

Who is online

Users browsing this forum: Yahoo [Bot] and 10 guests