| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem formatting date as "dd/mm/yyyy"
Hi,
I am formatting cells using the following code: sws1 is the source sheet and dws is the destination sheet. dws.Cells(datarow, 3) = Format(sws1.Cells(j, 6), "dd/mm/yyyy") The value of "31-03-2010" in sws1 is displayed as "31-03-2010" in dws and not as "31/03/2010" as desired. The cell in dws is formatted as general The value of "12-03-2010" in sws1 is displayed as "03-12-10" in dws and not as "12/03/2010" The cell in dws is formatted as date. The dates in the sws1 sheet are formatted as dates Please help iwith the correct code formatting to display as desired. Thanks in advance for the help. Regards, Raj |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem formatting date as "dd/mm/yyyy"
Try
dws.Cells(datarow, 3) = sws1.Cells(j, 6).Value dws.Cells(datarow, 3).NumberFormat = "dd/mm/yyyy" -- Jacob (MVP - Excel) "Raj" wrote: Hi, I am formatting cells using the following code: sws1 is the source sheet and dws is the destination sheet. dws.Cells(datarow, 3) = Format(sws1.Cells(j, 6), "dd/mm/yyyy") The value of "31-03-2010" in sws1 is displayed as "31-03-2010" in dws and not as "31/03/2010" as desired. The cell in dws is formatted as general The value of "12-03-2010" in sws1 is displayed as "03-12-10" in dws and not as "12/03/2010" The cell in dws is formatted as date. The dates in the sws1 sheet are formatted as dates Please help iwith the correct code formatting to display as desired. Thanks in advance for the help. Regards, Raj . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem formatting date as "dd/mm/yyyy"
Hi,
Raj please format the destination cell as "dd/mm/yyyy" right click the cell, click on format cell, select custom in number tab, then in the Type box please type "dd/mm/yyyy" press ok Regards, Usman "Raj" wrote: Hi, I am formatting cells using the following code: sws1 is the source sheet and dws is the destination sheet. dws.Cells(datarow, 3) = Format(sws1.Cells(j, 6), "dd/mm/yyyy") The value of "31-03-2010" in sws1 is displayed as "31-03-2010" in dws and not as "31/03/2010" as desired. The cell in dws is formatted as general The value of "12-03-2010" in sws1 is displayed as "03-12-10" in dws and not as "12/03/2010" The cell in dws is formatted as date. The dates in the sws1 sheet are formatted as dates Please help iwith the correct code formatting to display as desired. Thanks in advance for the help. Regards, Raj . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| user to input date as "yyyy" in cell | Excel Programming | |||
| Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date? | Excel Programming | |||
| Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD - ho | Excel Discussion (Misc queries) | |||
| Using "dd/mm/yyyy h:mm" on Date Variables | Excel Programming | |||
| Option Explicit and Date Format "dd mmm yyyy"? | Excel Programming | |||
![Raj[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
