Hi All:
I am looking for the easiest way (formula?) to remove the decimal from a number and have the answer as text.
For Example:
A1 is $24 500.00 and I want the formula to return 2450000
A2 is $26 767.98 and I want the answer to be 2676798
How can i accomplish that? I think it is pretty simple but that is the way I am feeling at the moment as well
THANKS,
Mark
I am looking for the easiest way (formula?) to remove the decimal from a number and have the answer as text.
For Example:
A1 is $24 500.00 and I want the formula to return 2450000
A2 is $26 767.98 and I want the answer to be 2676798
How can i accomplish that? I think it is pretty simple but that is the way I am feeling at the moment as well
THANKS,
Mark