Changing A Decimal Number To A Whole Number

[PhaiZe]

Guys, Need huge help here.

Just wondering if some could tell me how to change a decimal number to a whole number without changing the actual values.

Example,

Actual visible
A1] 0.500 -----> 500
B1] 0.365 -----> 365
Total] 0.865 -----> 0.865

See, the actual number are still the same but visually, its a whole number. All the numbers are avalible now and all in decimals, i want to change them to a whole number.

Help!

[zbor]

Try this..

=H10*("1"&REPT(0;LEN(H10)-FIND(",";H10;1)))

Little complicated because doesn't depend on how many numbers is after decimal point

only replace ; with , if you need and also, if decimal . chage "," to "."

[zbor]

Also, you didn't write what with those numbers (my formula return same)

Please Login or Register  to view this content.

[John_Franco]

Here is an idea...

Multiply your number by 1000:

0.500 * 1000 = 500
0.365 * 1000 = 365
...
0.023 * 1000 = 23
0.002 * 1000 = 2

Notes:
I assume you have three decimal places.