Add .00 Or 0 After A Number

Legacy Poster

• 2013年07月29日 18:08

Hi I have a data field called "Field: 1.Total Price" that is coming from a database and the database is taking away the .00 or 0 for example if it is 7.00 it is giving me 7 or if it is 7.10 it is giving me 7.1 how can I add it in bartender using a vb script Thank you

0

• 

  Domingo Rodriguez

  モデレータ

  ★ BarTender Hero ★

  • 2013年07月30日 08:49

  You can use FormatNumber() or FormatCurrency() methods. They're both described in BarTender's Help for VBScript ("Help > Visual Basic Script Help").

   

  An OnProcessData VBScript example would be:

   

  value = FormatNumber(value, 2)

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 2013年07月30日 16:04

  Thanks work great

  0

サインインしてコメントを残してください。