Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Convert a Currency value to number
#5
Solved: 11 Years, 8 Months, 3 Weeks ago
Saket -
You know what, I looked at egun's code and saw that he was reffering closely to the numeric conversions. But if it deals or anything dealing with Currency formats etc..cdbl is an excellent option.

Thanks saket for bringing it up and sharing it.

Egun - You have 2 options now :-) pick your choice.

Unsure why i have no option to Edit..it throws a error. Just a quick snippet about CDBL.

This one from QTP Help...

Use the CDbl function to provide internationally aware conversions from any other data type to a Double subtype. For example, different decimal separators and thousands separators are properly recognized depending on the locale setting of your system.

This example uses the CDbl function to convert an expression to a Double.

Dim MyCurr, MyDouble
MyCurr = CCur(234.456784) ' MyCurr is a Currency (234.4567).
MyDouble = CDbl(MyCurr * 8.2 * 0.01) ' Convert result to a Double (19.2254576).

- basanth
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Reply


Messages In This Thread
Convert a Currency value to number - by egun - 08-10-2009, 09:22 PM
RE: Convert a Currency value to number - by Saket - 08-11-2009, 10:33 AM
RE: Convert a Currency value to number - by Saket - 08-11-2009, 11:05 AM
RE: Convert a Currency value to number - by basanth27 - 08-11-2009, 11:18 AM
RE: Convert a Currency value to number - by egun - 08-11-2009, 09:45 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  [UFT] Get Item of ListBox and convert it to array felino 1 2,606 11-26-2015, 02:20 PM
Last Post: felino
  How to convert a single dimension array to two dimensional array venkatesh9032 3 5,929 02-10-2014, 03:07 PM
Last Post: pranikgarg
  How to convert integer to decimal automation2012 2 5,712 03-25-2013, 04:44 PM
Last Post: automation2012
  How to convert three arrays into just ONE array? Arena 2 5,268 04-10-2012, 09:35 AM
Last Post: Arena
  "How to convert StringName to FunctionName" suresz449 0 2,450 08-30-2011, 04:01 PM
Last Post: suresz449

Forum Jump:


Users browsing this thread: 2 Guest(s)