Posted to microsoft.public.excel.programming

Oz Viking[_2_] Oz Viking[_2_] is offline

external usenet poster

Posts: 1

Wrong dates in VBA

I have columns with of dates. eg 1/07/2009 meaning 1 July 2009. When I copy
this date using VBA and paste it to another range, it changes to 7/01/2009
and produces incorrect reports ie as 7 January 2009. It is obviously a US
date thing but I don't know how to fix it.

Please 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
Adding columns using dates, but getting wrong data	Griffey5	Excel Worksheet Functions	3	January 8th 09 03:29 AM
Dates Being displayed the wrong way around.	NateBuckley	Excel Programming	2	April 13th 08 02:26 PM
Dates appear wrong in my chart	Rockman	Charts and Charting in Excel	1	January 11th 08 11:46 PM
dates automatically formatted wrong	bigajosepi	Excel Discussion (Misc queries)	1	August 22nd 06 04:56 AM
I get wrong dates when i paste from a different sheet into a new s	mmollat	Excel Discussion (Misc queries)	2	January 6th 05 07:35 PM

All times are GMT +1. The time now is 09:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us