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.
|