Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel 2003
Name: Betty Mc Kenzie Date: November 14, 2006 at 11:50:33 Pacific OS: Xp CPU/Ram: 1.4gig
Comment:
Can somneone help me with a formular to convert the date 12/11/2001 to 12112001
Name: Bryco Date: November 14, 2006 at 13:03:17 Pacific
Reply:
I can not formulate it correctly. Why do you want to do it? Is it because you want to be able to calculate the differences between dates or give it a numeric value?
If so then format the cells as numbers. 12/11/2001 converts to 37236.
HTH Bryan
0
Response Number 2
Name: Grok Lobster Date: November 14, 2006 at 20:46:12 Pacific
Reply:
Go to Format Cells and choose Custom. Find the entry that shows m/d/yyyy and select that. Use the arrow keys to remove the slash marks so that you have mdyyyy, and you are done. No guarantees about what will happen if you calculate from it.
0
Response Number 3
Name: wizard-fred Date: November 15, 2006 at 00:15:02 Pacific
Reply:
You can get there going the long way around. Date to Numbers to String but not necessarily back to a number (depends if you need a leading zero).
0
Response Number 4
Name: Betty Mc Kenzie Date: November 15, 2006 at 05:52:38 Pacific
Reply:
Just some clarification - I have about 1500 dates in Excel with the format 12/11/2001. I am inporting them into a database that has to have the import format as 12112001. (without the slashes) It is difficult to change them individually. Thanks
0
Response Number 5
Name: Jennifer SUMN Date: November 15, 2006 at 10:04:06 Pacific
Reply:
What format is the database field you're importing to? I'm not aware of any pre-configured input masks for dates that do not contain the slashes.
Perhaps a little more information would help.
If you're changing the Excel cells, you don't have to do them individually. Change the format of the entire column if they're all in the same column.
Life is more painless for those who are brainless.
Summary: I have created the excel file in excel 2003 and transfered it to excel 1997 in my 2nd computer. However when i tried to save the file in excel 1997, i get the error message that some cells have more t...
Summary: when i start excel 2003 it pop up a message "cannot find C:\program files\office 2003.....\analysis\funcres.xla" . earlier i had removed the funcres.xla from this location. please help ...
0 
Problem with Outlook Sign...
