Questions & Answers for: change date format excel

Question about QuickBooks Premier: Accountant Edition 2003 (275957) for PC

1 Answer

...change date format from mm/dd/yyyy to dd/mm/yyyy If it's anything like Excel, someplace in the FORMAT menu should be options to allow you to change the date format. (Block off the cells, row, or ...

Ad

Question about QuickBooks Premier: Accountant Edition 2003 (275957) for PC

2 Answers

...NUMBER tab, choose TEXT. This will make your dates appear exactly as they are typed, and not allow Excel to reformat them. Just use comment at the beginning of cell to change the date format to

Ad

Question about (SS8SATAS5128400R)

1 Answer

...Date/ selected particular format. some dates still showing previous. some cells only accepting the change. Hi, I am using MS-2007, i got the solution upto some level only. i can't say exactly whether ...

Question about Excel for PC

2 Answers

...date format even when the excel sheet is ready to accept numbers. Thanks for help. [email protected] it should be =7/4 or =100/30 and excel will give you a numeric result. change cell format (ctrl-1) to ...

Question about Excel for PC

1 Answer

...date format. I need to have it read as follows: Purchased 12/21/2006 Estimated Life 12/21/2009 Purchased 12/21/2001 Estimated Life 12/21/2005 How to I calculate years using a starting date and having ...

Question about Office Professional 2007 Full Version for PC

1 Answer

...date format. I format the column to ensure the date is in English format ie day, month, year but when I merge it to word it changes it to the american format month, day year yet the word document is ...

Question about Office Excel 2003 for PC

1 Answer

...to change theses dates by hand or is there a way to use the format commands? There are a lot of dates to change so any help would be appreciated. Thanks, Les i want professional office 2007 product ...

...change I have this date format 2004.04.01 and would like to change it to 01-Apr-2004. pls. share your thoughts. thanks In the cells/columns/rows you want to show that way, highlight them, and then ...

Question about Windows XP Professional SP3 Full Version OEM for PC

1 Answer

change the format of dates to simple numbers I have a transformed a column of birthdates to years (through help from F3ar13ss). Excel still treats them as birthdates. I would like now to create a new ...

...as experimental cell off to the side of the spreadsheet. All will not produce the correct date. Change the format to General, and see if you get a number like 40105, which is the same as

Not finding what you are looking for?

Ask a Question

Usually answered in minutes!

Popular Products

Top Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

Brad Brown

Level 3 Expert

19187 Answers

Cindy Wells

Level 3 Expert

6688 Answers

Are you a Computers & Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...