Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DataType Conversion
Iam submitting some data from VB using ADO to Excel sheet.
like rs.addnew rs("sal")=formatcurrency(rss("sal")) rs.update every thing work fine but iin excel sheet in have text value for above column(sal). Can any one help me How I can change data type so my excel sheet have same datatype as in database Thnx in Advance --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data. Problem with datatype in column | Excel Discussion (Misc queries) | |||
How do I validate the datatype of a cell's value in Excel 2007? | Excel Discussion (Misc queries) | |||
Save as a dbf file changes datatype | Excel Discussion (Misc queries) | |||
Vlookup datatype(?) issue | Excel Worksheet Functions | |||
How do I change the datatype of a cell? | Excel Programming |