Excel Question
| Posted By | Message |
|---|---|
|
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. |
|
Posted 3/20/09 9:25 PM
|
|
|
Long Island Weddings
Long Island's Largest Bridal Resource
| |
|
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... Message edited 2009-03-20 21:28:56.803000. |
|
Posted 3/20/09 9:27 PM
|
|
|
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
|
|
|
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. |
|
Posted 3/20/09 10:50 PM
|
|
|
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. |
|
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 ™ |





