Posted to microsoft.public.excel.programming

alexm999[_82_] alexm999[_82_] is offline

external usenet poster

Posts: 1

Date Format Issue

I have a file that exports a date in the following format:
2003.12.30
2004.5.11

Its the year, month and then day. BUt I cannot use cell formating t
change the date format to:
Month/Day/Year

How can I do this using programming.
The data is always in column

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Please help....Date Format issue	SandyW	Excel Discussion (Misc queries)	1	January 7th 09 07:29 PM
date format issue	Arjen	Excel Discussion (Misc queries)	3	August 22nd 06 02:04 PM
DATE FORMAT issue	[email protected]	Excel Worksheet Functions	1	February 8th 06 07:52 AM
Date format issue	LadyDoe	Excel Worksheet Functions	1	November 17th 05 07:54 AM
Another Date Format issue	Wayne Nelson	Excel Programming	1	December 4th 03 06:27 AM

All times are GMT +1. The time now is 07:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us