Need help

  • Thread starter Thread starter Henry
  • Start date Start date
H

Henry

when I copy a table into excel and one field contains a expression like 2-1
or 3-1 or 3-2 excel automatically formats the field to custom date

how can I turn this off
so whatever I paste into cell excel will display it as it is

thanks
 
Henry, try to format the cells as text before you put the data in

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
1- please title your subject with something someone other than yourself can
make sense of

2- format the cell as text, then paste the values special as text.
 
Back
Top