+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: Simple Excel help (/showthread.php?tid=95740)
Pages:
1
2
Re: Simple Excel help - Ironhorse - 04-14-2010
I did past values and then it changed the date format to a 5 digit number, I then selected format cells and clicked on date and it still changes the year of the date. Thanks for everyones help but I will quit for the night and try tomorrow.
Thanks
Re: Simple Excel help - Ironhorse - 04-14-2010
I new it was simple, it was the 1904 date system...in the excel preferences.
Re: Simple Excel help - Greg - 04-14-2010
Hi!
You want to make sure that the date system is...
...oh, crap. Sorry I'm late.
Re: Simple Excel help - Paul F. - 04-14-2010
Greg.. you're slipping man..
Took over an hour for you to get here :-)
Re: Simple Excel help - Greg - 04-14-2010
Sorry, sorry...was afk.