I use Microsoft Office Spreadsheet 10. I connect spreadsheet to a web page.
İt brings data correctly but some cells view wrong format.
some cells (like " 1-1 " ) view date format (like " 1-January"). How can fix it ?
Printable View
I use Microsoft Office Spreadsheet 10. I connect spreadsheet to a web page.
İt brings data correctly but some cells view wrong format.
some cells (like " 1-1 " ) view date format (like " 1-January"). How can fix it ?
When reading the cells you need to use the appropriate number format.
Format your column/cells as the desired format first otherwise Excel has to guess at the expected data type and may get it wrong.
Spreadsheet has no contain string format feature. to use general format not work. otherwise if I use excel , it contains "dont date identify feature" and it works but spreadsheet activex has no contains this feature. Can I do promrammatickly?