Remove decimal from number

message from MA on 19 May 2004
What is the best way to remove the decimal from a number?

Convert 123.30 to 12330
 
RobFMS replied to MA on 19 May 2004
In this case, I would suggest using the REPLACE() function.

Replace ( "123.30", ".", "")
 

Archived message: Remove decimal from number (MS Access Forms)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.