Manipulate Decimal Values in EXCEL + VB

Asked

Viewed 67 times

0

I have an application that provides a webservice(Ws) (java) but I need to carry data to an excel sheet and print, my problem is, when I get Ws values depending on the operating system’s Reginal Setting, I get them in different formats Ex: 90.01 or 9001, when it does not bring the point it reads as an integer and I need to have it as decimal. Changing egional Setting is not a valid solution as I cannot force the user to do so, so I look for a way to get the correct value (90.01) with VB.

Does anyone there have any solution or hint that helps?

  • You could not convert the entire data before transporting it to Excel and create a routine in Excel treat it?

  • 1

    There is another application that uses the webservice and this ok, and besides that I need the decimals.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.