excel and vb
Posted on 2006-06-14
I have a program that populates an excel spreadsheet.
When I have numbers like below stored into my db (as a string), I can populate without a problem.
When I use a number stored as a string like .000032 and format it like
Format(tmpRS("calculatedValue"), "#.0000E+00") it works well.
When I try to add a "+" sign before it, it will not show up in excel.
"+" & Format(tmpRS("calculatedValue"), "#.0000E+00") strips the "+"
since everything is a string, why does it work when it comes out of the db in that format, but it won't work when I build it on the fly?