Return to Forum Index
Profile Memberlist Search Scout Report Register

Martinwatch spreadsheet date format question.

 
Post new topic   Reply to topic     |##| -> |=|     Return to Forum Index -> Purple Martin Forum
View previous topic :: View next topic  
Author Message
WV Martineer



Joined: 28 Jun 2006
Posts: 478
Location: Waverly/ West Virginia
PostPosted: Sun Jun 22, 2008 12:24 pm    Post subject: Martinwatch spreadsheet date format question. Reply with quote

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?

_________________
Making the bird world better, one ratbird at a time.
Back to top
View user's profile Send private message
Oakley, Ron and Liz



Joined: 23 Apr 2008
Posts: 411
Location: FL/Ocala
PostPosted: Sun Jun 22, 2008 6:06 pm    Post subject: Reply with quote

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

_________________
Liz O.
Blessed is the nation whose God is the Lord.
Psa.33:12
Back to top
View user's profile Send private message Send e-mail
gussiemike



Joined: 09 Jun 2008
Posts: 24
Location: Baton Rouge, LA
PostPosted: Sun Jun 22, 2008 6:12 pm    Post subject: dates on spread sheet Reply with quote

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.
Back to top
View user's profile Send private message
WV Martineer



Joined: 28 Jun 2006
Posts: 478
Location: Waverly/ West Virginia
PostPosted: Sun Jun 22, 2008 7:26 pm    Post subject: Reply with quote

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.
_________________
Making the bird world better, one ratbird at a time.
Back to top
View user's profile Send private message
Oakley, Ron and Liz



Joined: 23 Apr 2008
Posts: 411
Location: FL/Ocala
PostPosted: Sun Jun 22, 2008 7:34 pm    Post subject: Reply with quote

BUMMER!!!!!!!!!!!
_________________
Liz O.
Blessed is the nation whose God is the Lord.
Psa.33:12
Back to top
View user's profile Send private message Send e-mail
KathyF



Joined: 24 May 2007
Posts: 2918
Location: Missouri/Licking
PostPosted: Mon Jun 23, 2008 1:43 pm    Post subject: Reply with quote

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 Laughing

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
http://kathyfreeze.blogspot.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     |##| -> |=|     Return to Forum Index -> Purple Martin Forum All times are GMT - 5 Hours
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group