Hello...need a quick answer if anyone can help out....
I'm trying to format about 10,000 prices to end up having no decimals but retaining the numbers...not the value.
For example:

$315.50

to

31550

I've tried multiplying by 100 and copying the formula down the column, but it's only giving me the initial value although when you click on a cell it's showing that the cell should be reading differently. If that makes any sense...I've been doing this for almost 3 hours now...pleeeease help!!