T
tracey
i have an excel spreadshee that is populated from another
application. The users may be cutting and pasting data
into the spreadsheet. the data seems to be formatted
automatically as text. If some data should be currency the
data is acutally stored with a "$", which would make it
text. I wrote some code that eliminated the "$" for every
record. Now I am having trouble converting the text to a
numeric, currency or double data type. It also doesn't
seem to like zeros. zero is stored as 0.00, when it should
be 0. Any comments on what I should do?
application. The users may be cutting and pasting data
into the spreadsheet. the data seems to be formatted
automatically as text. If some data should be currency the
data is acutally stored with a "$", which would make it
text. I wrote some code that eliminated the "$" for every
record. Now I am having trouble converting the text to a
numeric, currency or double data type. It also doesn't
seem to like zeros. zero is stored as 0.00, when it should
be 0. Any comments on what I should do?