I am using the following code to read numerical data from an Excel spreadsheet to a string variable.
dim amount as string
Set xLApp=new Excel.application
The problem is that it is dropping the zeros in the cents portion of the number.
So if the Excel cell data is 100.20 then amount variable is 100.2
Or if the Excel cell data is 100.00 then amount variable = 100.
I need to be able to read the whole number.