bonitashar Posted November 14, 2002 Share Posted November 14, 2002 I have run into a few problems trying to import and export dates and time. Let me try to explain what the problem is and what I need and see if there are any solutions. 1- When exporting time to Eudora it shows up as military time but I would like to have an am/pm format. Can this be changed? The next few problems come from excel worksheets that contains statements we receive every quarter. 2- I have an excel worksheet that one of the fields contains three types of data: -it is blank -Date formated as December 3, 2002 -the Date plus a string of unnecessary words The problem is I need to extract just the date and have it formated as mm/dd/yyyy. 3- In the same excel worksheet there is a field that contains the year and a number representing the quarter. ex: 20011 (year 2001 quarter 1). I need to have this changed to the last date of the quarter ex: March 31, 2001. I hope this makes sense and that someone can help. Thank you. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7969 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now