This likely isn't that difficult, but I'm not getting the expected result. When the user enters a quantity in a form textbox, I would like the
resulting value be wrapped in parentheses on the worksheet.
So this should result in (2), or whatever quantity they enter. What I'm getting with this line of code as shown is -2 without ()
Please Login or Register to view this content.
Thank You
Another example of how Excel tries to help us and hurts us instead. What is happening is that Excel is seeing (2) as an accounting type value that represents -2, so it is reinterpreting the entry as -2. The solution here is to figure out some way to get Excel to see this entry as text rather than a number.
I do not have a lot of experience with getting Excel to treat inputs as text rather than number. My first thought is to preformat this cell as text (numberformat="@") and hope that will be enough to prevent Excel from interpreting this as a -2. You could also try adding an apostrophe to the front of the string, which should signal to Excel that this is a text string and not a number. There may be other strategies, too.
Originally Posted by shg
Thank you Mr
I tried setting the cells to "text", it did get rid of the negative sign but didn't add the ().
It did override the center text setting and placed the result left aligned. Maybe I need to hardcode the text type
if you just want it to display correctly you can add the ' before it
*edited to remove my teststuffPlease Login or Register to view this content.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
Thank you, adding the apostrophe lets it work correctly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks