| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Format
Dear all, Win local format is "dd/mm/yy" in VBA Cells(1, 1) = "08/02/2006" in Excel sheet display "02/08/06" in A1 What happen? -- gabch ------------------------------------------------------------------------ gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662 View this thread: http://www.excelforum.com/showthread...hreadid=536337 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date Format
Hi Gabch,
Try: Cells(1, 1).Value = DateValue("08/02/2006") --- Regards, Norman "gabch" wrote in message ... Dear all, Win local format is "dd/mm/yy" in VBA Cells(1, 1) = "08/02/2006" in Excel sheet display "02/08/06" in A1 What happen? -- gabch ------------------------------------------------------------------------ gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662 View this thread: http://www.excelforum.com/showthread...hreadid=536337 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date Format
The Windows Regional Settings dictates, among other things, how Excel should
present dates. However, the VBA code is primarily using US format for dates. Hence, Cells(1, 1) = "08/02/2006" means 02-Aug-2006 (US mm/dd/yyy), and it then gets translated into "02/08/2006" (which means 02-Aug-2006 in your UK format) during the presentation stage, i.e., when Excel displays the date in cell A1. By the way, you can also use the following construct in the futu Cells(1, 1) = #2/8/2006# The #..# literal is explicitly of type Date (and, yes, it's in US format) so you know what you'll get. A string, however, can basically be anything you like... Cheers, /MP "gabch" wrote: Dear all, Win local format is "dd/mm/yy" in VBA Cells(1, 1) = "08/02/2006" in Excel sheet display "02/08/06" in A1 What happen? -- gabch ------------------------------------------------------------------------ gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662 View this thread: http://www.excelforum.com/showthread...hreadid=536337 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date Format
Hi, How can I convert UK date format(dd/mm/yy) at cell to US format (mm/dd/yy) through VBA -- gabch ------------------------------------------------------------------------ gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662 View this thread: http://www.excelforum.com/showthread...hreadid=536337 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
| Convert european foreign date format to US date format | Excel Worksheet Functions | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
| code to convert date from TEXT format (03-02) to DATE format (200203) | Excel Programming | |||
| Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming | |||
![gabch[_16_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
