MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

Posted by Aladin Akyurek on March 03, 2001 2:23 PM

Jim: Try

B1 =10^(LEN(A1)-FIND(".",A1))*A1

By the way, why do you want to do this?