View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Isa
 
Posts: n/a
Default How do I delete hidden character in Excel?

Hi,
I have exported a table from Access 2000 to Excel 2000.
However, all the fields have a hidden character in front which is '
I am unable to do any formulas as it doesn't recognise it as a number but
has the number format.
I can't get rid of it when doing a search and replace either.
Can you help?

Thanks.