Remove decimal but keep entire number
For excel, changing $47.50 to 4750 is not a "display" issue. You need to
multiple it by 100 and put it in another column, and format that column
number with 0 decimals.
"Tickfarmer" wrote:
I need the price to display with no decimal, but retaining the numbers that
appear after the decimal. For example $47.50 would be 4750.
Example 119.00 would be 11900
Please help
--
Tickfarmer
|