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

Hi Isa. You might also use the Value function. This will transform the text
you exported from Access to a number. Assume your data is in A1 to A100, in
B1 type =Value(A1) and copy down to B100. Then copy B1:B100 and Paste
Special - Values into A1:A100. HTH
--
Sincerely, Michael Colvin


"Isa" wrote:

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.