How can I make Number fields not to show .00 at the end

This topic is locked

How can I make Number fields not to show .00 at the end	7/12/2007 11:56:35 AM
ASPRunnerPro General questions
Alberto author In some cases I have columns that are numbers but not necesarilly are using the .00 at the end. How can I eliminate that. Is there a place to choose how many decimal I want to show or not show. Some times I also have screens that show moneywhere I dont want to show cents at all. How can I eliminate those? Thanks

2 replies


	Sergey Kornilov admin 7/12/2007
	Alberto, you can use "View as" type "Custom" and the following code: `strValue = FormatNumber(strValue,0)`

2 replies