View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default Deleting the "'" character in the text formula

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