| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set user defined format in VBA
Dear all,
I want to set a Column with user defined format yyyy-mm-dd. How can I do that in VBA? I guess the sentence should look like this : Columns("B:B").????? = "yyyy-mm-dd" Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to set user defined format in VBA
Columns("B").NumberFormat = "yyyy-mm-dd"
Columns(2).NumberFormat = "yyyy-mm-dd" Either one of those should work. Charles Chickering hon123456 wrote: Dear all, I want to set a Column with user defined format yyyy-mm-dd. How can I do that in VBA? I guess the sentence should look like this : Columns("B:B").????? = "yyyy-mm-dd" Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to set user defined format in VBA
columns(2).Numberformat = "yyyy-mm-dd"
-- Regards, Tom Ogilvy "hon123456" wrote in message ups.com... Dear all, I want to set a Column with user defined format yyyy-mm-dd. How can I do that in VBA? I guess the sentence should look like this : Columns("B:B").????? = "yyyy-mm-dd" Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| user defined functions format | Excel Discussion (Misc queries) | |||
| Custom Format for User Defined Function | Excel Discussion (Misc queries) | |||
| User-defined data type; Error: Only User-defined types... | Excel Programming | |||
| User Defined Function: Format Output | Excel Programming | |||
| User-defined function with a naming format of =ABC.XYZ. | Excel Programming | |||
Linear Mode
