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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formatiting a decimal number within a formula 1

Status
Not open for further replies.

checkai

Programmer
Jan 17, 2003
1,629
US
I have a number that is recognized with decimals and commas...that I want to compare to a string that has no decimals nor commas....

ex: 200308 is compared to 200,308.00

I need to format the number so that they are equal!!

Should be easy, just not sure how to do it.

thanks,
dlc
 
totext({numberfield}, "#") will give the numberfield as text with no decimals or commas.

Lisa
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top