Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
column format
Hey, I have a macro that does a bunch of stuff, but before it does that stuff I want it to format a column which holds a date value, I want it to format the columns cells so that the date format is m/d/yyyy h:mm Does any one know how I would go about this? -- snowing ------------------------------------------------------------------------ snowing's Profile: http://www.excelforum.com/member.php...o&userid=34576 View this thread: http://www.excelforum.com/showthread...hreadid=547201 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
column format
"snowing" wrote: Hey, I have a macro that does a bunch of stuff, but before it does that stuff I want it to format a column which holds a date value, I want it to format the columns cells so that the date format is m/d/yyyy h:mm Does any one know how I would go about this? -- snowing ------------------------------------------------------------------------ snowing's Profile: http://www.excelforum.com/member.php...o&userid=34576 View this thread: http://www.excelforum.com/showthread...hreadid=547201 If the macro only refers to one worksheet. Use the macro recorder and record the formatting you apply to the column. Copy the code it creates into your main macro. If the macro jumps from sheet to sheet you may need to modify this code accordingly. HTH |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
column format
snowing wrote: Hey, I have a macro that does a bunch of stuff, but before it does that stuff I want it to format a column which holds a date value, I want it to format the columns cells so that the date format is m/d/yyyy h:mm Does any one know how I would go about this? -- snowing ------------------------------------------------------------------------ snowing's Profile: http://www.excelforum.com/member.php...o&userid=34576 View this thread: http://www.excelforum.com/showthread...hreadid=547201 Columns("A").numberformat = "m/d/yyyy h:mm" HTH Die_Another_Day |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i change column header from R[1] C format to A1 format? | Excel Discussion (Misc queries) | |||
format cells in one column based on value in another column | New Users to Excel | |||
Format column to link file names in that column | Excel Discussion (Misc queries) | |||
How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions | |||
How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions |