Text to Number?

  • Thread starter Thread starter Steve Almond
  • Start date Start date
S

Steve Almond

When I copy data from a webpage into a spreadsheet, I often have an obvious
currency value (£36.40) but cannot operate on it with arithmetic functions
(say divide it by 2). I've tried using the VALUE() function without success.

Is there an answer?

Thanks,

Steve
 
Try this

Copy a empty cell
Select the cells with (£36.40))
Right click on the selection
choose Paste Special
Check Add
Ok
 
Can't see 'Text' when I use paste special!

Steve


Try doing a paste special rather than a paste. Select
text!

Don
 
Ron,

This isn't working in my case.

Steve

Ron de Bruin said:
Try this

Copy a empty cell
Select the cells with (£36.40))
Right click on the selection
choose Paste Special
Check Add
Ok
Click to expand...
 
It looks as if you may have to select the data and Edit>Replace>*the
currency symbol*>Replace With>*leave blank*>Replace All>OK. Then perform the
steps posted by Ron de Bruin
 
Do an edit>replace and in the replace what box hold down alt while typing
0160 on the numpad,
release the alt key (it is an invisible html character so you won't see
anything), the leave the replace with box empty.
 
Thanks to all who answered.

I used Edit>Replace>*£*>Replace With>*leave blank*>Replace All>OK. No
further copy/paste special required. The cells all became simple numbers.
i.e. £36.24 became 36.24. Perfect!

Steve
 
Back
Top