how to overwrite excel date formatting

February 17, 2011 at 07:04:40
Specs: Windows Vista
I am exporting data from an online calendar as a csv file. After cleaning up the data I am then saving it as an Excel file to import into an Access table.

Here is my dilemma:

All of dates and times need to be formatted in ways that are not the formatting options in Excel or Access. How can I create rules to overwrite Excel formats to get the formatting I need?

Thanks!


See More: how to overwrite excel date formatting

Report •


#1
February 17, 2011 at 13:01:37
Excel formats to get the formatting I need?

What are the formats that you need?

MIKE

http://www.skeptic.com/


Report •

#2
February 17, 2011 at 14:21:31
I need the date format to be like this example:

Thursday, Feb. 17

I don't need the month spelled out or the year as in the long date option,

The time format needs to be like this example:

5 PM or 5:30 PM

The option on Excel always throw 00s in when the time is on the hour.

Thanks for quick response.


Report •

#3
February 17, 2011 at 15:51:04
Are the Date & Times in the same cell, or in separate cells?

If there in the same cell try this Custom Format:
dddd mmmm d h:mm AM/PM

If there in separate cells, just break it apart:

Date = dddd mmmm d
Time= h:mm AM/PM

Still gives you the zeros at 5:00 PM, but it's as close as I can get right now.
I'll keep working on it.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question