Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Storing data and its format
Hi all!
I work with OLE, and want to do this: somecell.value = some date (which i have in mm.dd.yyyy format numberformat = "yyyy" // year only nextcell.value = previous cell numberformat = "mmm" // month as name I have tried this, but it does not work: $WB-Sheets(1)-Cells($excel_index,1)-NumberFormat="mm.dd.yyyy"; $WB-Sheets(1)-Cells($excel_index,1)- Value=GetMyDateFormat(odbc_result($result,3)); $WB-Sheets(1)-Cells($excel_index,1)-NumberFormat="yyyy"; $WB-Sheets(1)-Cells($excel_index,2)-NumberFormat="mm.dd.yyyy"; $WB-Sheets(1)-Cells($excel_index,2)- Value=GetMyDateFormat(odbc_result($result,3)); $WB-Sheets(1)-Cells($excel_index,2)-NumberFormat="mmm"; GetMyDateFormat returns the date in "mm.dd.yyyy" format. Is there an Excel guru here? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
storing real time data | Excel Discussion (Misc queries) | |||
storing data | Excel Worksheet Functions | |||
Is Excel good for storing data that constantly updates? | Excel Discussion (Misc queries) | |||
Storing Formulas to Use | Excel Worksheet Functions | |||
Storing data | New Users to Excel |