View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alogon Alogon is offline
external usenet poster
 
Posts: 6
Default Retrieving the characters lost

Hello everybody.

When I convert a txtfile into xlsfile, a cell that must contain the text "-
John" (ignore quotation marks) become a formula "=- John" (ignore quotation
marks). In the worksheet, Excel displays the value "#Name?" (ignore quotation
marks) at that cell and displays "=- John" (ignore quotation marks) at the
edition bar.

Using VBA, how can I get back the original characters "- John" ?

Thank you in advance.