Excel Question

Posted By Message

MissJones
I need a nap!

Member since 5/05

22152 total posts

Name:

Excel Question

I'm trying to put all of our tax info into an excel document and I have a column for the date. It's doing an awesome job of turning 1/21 into Jan. 21, 2009, but I want these to be in 2008 format.

How do I change it so that all the dates read 2008?

Thanks!

Posted 3/20/09 9:25 PM
 
Long Island Weddings
Long Island's Largest Bridal Resource

TheDivaBrideandTeddyFrog
Leah's here!

Member since 9/07

5404 total posts

Name:
Sabrina

Re: Excel Question

i think you just put the date with year...as in..not just 1/21...let me know if you need more help with this..DH's thing is Excel spreadsheets...

ETA I just tried it and put in the date as 1/21/2008 and then changed the format under format-cells and it worked...

Message edited 2009-03-20 21:28:56.803000.

Posted 3/20/09 9:27 PM
 

MissJones
I need a nap!

Member since 5/05

22152 total posts

Name:

Re: Excel Question

I'm trying. I think I just have to go back and change all the 9's to 8's. Thanks anyway.

Posted 3/20/09 9:41 PM
 

Christine
2nd verse same as the 1st

Member since 5/05

15287 total posts

Name:

Re: Excel Question

If you need to see the year ~ format the column in mm/dd/yy format and type in the whole date 1/21/08.

If you don't need to see the year ~ format the column as mm/dd

or

~change the date on your computer to 2008 while you work on your schedule and then change it back when you are done.

Posted 3/20/09 10:50 PM
 

BabyBoy
is Skylar Elizabeth

Member since 5/05

4189 total posts

Name:
Tom

Re: Excel Question

excel will automatically think you have a current date. Yes, you will have to change all the dates or you can do a Find/Replace to change the year from 08 to 09.

I would find 2009 and replace with 2008

Posted 3/20/09 11:16 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
Excel question... igottabeme 1/22/08 4 Families Helping Families ™
URGENT EXCEL QUESTION kerrycec03 10/18/07 8 Families Helping Families ™
Excel Question spooks 8/22/07 1 Families Helping Families ™
Excel Question spooks 6/8/07 2 Families Helping Families ™
Excel masters - a question SweetestOfPeas 5/18/07 18 Families Helping Families ™
Dumb excel question JenniferEver 4/23/06 3 Families Helping Families ™