Deleting the "'" character in the text formula
Hi John,
Try this: highlight the column with the formulae you would like to
change, click on Data | Text-to-columns and then click Finish on the
first panel.
Hope this helps.
Pete
Niek Otten wrote:
Hi John,
Edit|Find and replace?
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"John" wrote in message ...
| Hi,
|
| I have a load of formulae currently displayed as text. This is not a case
| of converting using the 'Number' from the Category selection.
|
| At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
| to the ' then deleting it and hitting the Ente key. I dont fancy doing this
| for a couple of hundred cells. Any solutions to this would be appreciated.
|
| Thanks
|
| John
|