I have a problem that's causing much frustration:
- I set my OS' regional settings to English (US) but changed the short date format to the more sensible dd/mm/yyyy
- I have columns in Excel that are formatted dd/mm/yy
- When I use Cells(1, 3).Value = "01/02/03" where C is one such column, "02/01/03" appears!
Why is Excel changing this? Why does it think I would use .Value = and specify the incorrect format. How can I solve this problem?
Thanks
-jt
It's better to use:
Dom
Cells(1, 3).Value2 = DateSerial(2003, 2, 1)
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
The problem comes because Excel is implicitly converting the string you are applying to a date and it does this according to our US Chums' practice of mm/dd/yy. Dom's given you one way (the best), another would be:
Cells(1, 3).Value = DateValue("01/02/03")
Richard Schollar
Microsoft MVP - Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks