| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Excel cell format
I need to export data to an excel file programmatically. Date includes time
in form of min:sec and full date with time. IRange::PutValue2 accepts variant and if I pass COleVaraint created from COleDateTime I have excel show value as a double "39726.47661". I need to manually right click and select "Format Cells..." menu, then select Date or time Category and then the value is shown as I want. How can I do all this programmatically so that value is shown as date and time initially? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting special format for a cell | Excel Worksheet Functions | |||
| Setting Excel cell format | Excel Worksheet Functions | |||
| Setting an Icon Set conditional format for a single cell??? | Excel Discussion (Misc queries) | |||
| Setting a cell format based on a function operation | Excel Programming | |||
| Setting Cell Number Format With A Worksheet Function | Excel Worksheet Functions | |||
Linear Mode
