Posted to microsoft.public.excel.programming

JT[_2_]

external usenet poster

Posts: 96

converting dates

I have a macro that is used by both the international and
domestic operations.

I could use some help with the code to convertthe European
dates 170604 to 06/17/04.

The cells are formatted as general, so I don't get the
correct date if I try just formatting the cells.

Thanks for the help.

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
converting Dates	torpido	Excel Worksheet Functions	2	January 27th 15 10:24 AM
Converting to Dates	Trazza_UK	Excel Discussion (Misc queries)	5	November 1st 07 10:33 PM
Converting Julian Dates to regular dates	CDTucson	Excel Worksheet Functions	2	June 7th 07 04:20 AM
Converting Dates	Mike	Excel Worksheet Functions	2	July 11th 06 06:16 PM
converting dates	mike	Excel Programming	2	February 19th 04 11:31 PM

All times are GMT +1. The time now is 08:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us