Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number format no decimals 1

Status
Not open for further replies.

hlmnsbuggy

Technical User
Mar 25, 2002
72
US
CR 11

I have to type the following formula in display string

WhilePrintingRecords;
global numbervar a;
a:=CurrentFieldValue;
totext(a)

Now it reurens number with decimals. How can I return numbers without decimals?

Thanks for your help in advance!
Ann
 
try

totext(a,0,"")


HTH

-Steve


"if at first you don't succeed, sky diving is not for you"!!! :eek:)
 
Thank steve for your quick response. It works to get rid of decimals. Bu t how can I add , (1000 seperate)
Thanks again
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top