New here. This is a commonly asked question but cannot seem to find the answer specific to my issue.
Just got a refurbished computer Windows 7 Professional 32bit. Installed Office 2003 and Firefox 41.0.2. One of my regular tasks is to copy rows of data from a web page and paste it into Excel. Some of the cells become merged but all appear as in the original web page EXCEPT for the last cell (also a merged cell). This cell contains a currency value. When pasted into Excel, it becomes text, and cannot be used for calculations. The cell in Excel is formatted as Currency, but after pasting, becomes Text.
Example : $4.90 pasted into Excel LOOKS like $4.90 but the value INCLUDES the "$" sign.
My other computers don't have this problem. I have tried almost all the other solutions found on the web eg. converting the cells to numbers, paste special with multiply by a cell containing the value 1 etc.
I've found that after pasting the data, if I just delete the "$" sign, it works fine.