Friday, December 12, 2014

Remove leading 0 from number-formatnumber

Hi

Remove leading 0 from number using QTP. For example 0.09 should display. 09

Strtemp=0.09
Strnew=formatnumber(strtemp,,0)
Msgbox Strnew
'output is . 09

Strtemp=20000
Strnew=formatnumber(strtemp)
Msgbox strnew
'output is 20,000.00

Strtemp=formatnumber(20000,2)
'output 20,000.00
Strtemp=formatnumber(20000,5)
'output 20,000.00000 setting number of decimals
Strtemp=formatnumber(.30,,-1)
'output 0.20 with leading 0
Strtemp=formatnumber(-50,,,0)
'output -50.00 negative value
Strtemp=formatnumber(-50,,,-1)
'output (50.00) negative value inside parenthesis
Strtemp=formatnumber(1000000,,,,0)
'output 1000000.00 not grouping number
Strtemp=formatnumber(1000000,,,,0)
'output 1,000,000.00 grouping number

1 comment: