Ok, try this:
type the number 1 in a cell, now copy that cell, next select your data then
Edit/Paste Special and select Multiply hit ok.

HTH
JG


"chom krusopon" wrote:

Every month I work with a worksheet sent to me from another program. The
numbers look like these:

Amount
$44,000.00
$90,000.00
$115,000.00
$24,000.00

I tried coverting them to nubmers by first using =value() formula, that
doesn't work; I tried by formatting the cell to numbers, that doesn't work; I
tried using text data to column and that doesn't work neither. I ended up
having to first hit F2 to call up the numbers in each cell, then backspace
the cell 3 times and that method works. However, it's time consuming.

Anyone has a better idea? Please help. Thank you so much. Chom