Decimals to whole numbers
Posted by Jim McKane on March 03, 2001 2:04 PM
In my spreadsheet I need to return whole numbers for decimals. For example ".31" should be "31" and ".5" should be "5". The obvious problem is that you can't simply multiply by a constant because of the variable length of the numbers to right of the decimal point. How do I get my whole numbers?
Thank you very much.