Try this Use a Text field, in the text field put this formula format([Number1],"##0.00%")
R Ray McCoppin Aug 4, 2003 #1 Try this Use a Text field, in the text field put this formula format([Number1],"##0.00%")
M Michael Magan Aug 4, 2003 #2 Where can the syntax of the format function be found, and specifically the format string? The online help in MSP2000 is not very helpful. Ray said: Use a Text field, in the text field put this formula format([Number1],"##0.00%") -----Original Message----- I added a formula to the number1 field. How do I display the number1 field as a percentage, not an actual number. For example, my formula will return a result of .2 In the field, I would like to display it as 20% NOT .2 Is there a way to do this? Also, I could use another field type if this would work. Thanks for your help. Aaron Wiggans . Click to expand... Click to expand...
Where can the syntax of the format function be found, and specifically the format string? The online help in MSP2000 is not very helpful. Ray said: Use a Text field, in the text field put this formula format([Number1],"##0.00%") -----Original Message----- I added a formula to the number1 field. How do I display the number1 field as a percentage, not an actual number. For example, my formula will return a result of .2 In the field, I would like to display it as 20% NOT .2 Is there a way to do this? Also, I could use another field type if this would work. Thanks for your help. Aaron Wiggans . Click to expand... Click to expand...
