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? |
All times are GMT +1. The time now is 12:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com