Format 2 Decimal points

• DKlein

  SSCrazy

  Points: 2351

  More actions

  March 28, 2008 at 8:23 am

  #204827

  Hello all,

  I am trying to display two decimal points in a text box. I used a format code: #.## but it does not show a decimal point when the value has .00. How can I get it to show the value when it has and does not have decimal values? For example, values [.00 and .01].

  Thanks,

  DK

• toolman-352714

  SSCrazy

  Points: 2495

  More actions

  March 28, 2008 at 8:34 am

  #795229

  Try 0.00 instead of #.## or set the Format property of the text box to N2 (numeric with 2 decimal places) or D2 (decimal with 2 decimal places).

  Check these links for added number formatting help:

  Custom formatting:

  http://msdn2.microsoft.com/en-us/library/7x5bacwt(VS.71).aspx

  Standard formatting:

  http://msdn2.microsoft.com/en-us/library/dwhawy9k(VS.71).aspx

  HTH

  [font="Comic Sans MS"]toolman[/font]
  [font="Arial Narrow"]Numbers 6:24-26[/font]

• DKlein

  SSCrazy

  Points: 2351

  More actions

  March 28, 2008 at 9:07 am

  #795253

  Thanks Toolman,

  We ended up using F2. I used the standard formating link to test different formats.

  Thanks for the help,

  DK