I have an Excel file that I use like a check register. I copy data from my
bank on line and paste it into Excel. Now that I have upgraded to Excel 2007
I can't remove the bank formatting. I have followed ALL THE HELP INSTRUCTIONS
and have looked for something on line but can't seem to get an answer. I try
to remove the currency formatting and change to numbers with 2 decimals and
it won't change. The date is 5 numbers and I can't change to a date format.
As long as the currency icon is in my data I can not create formulas. I get
a #value. In the part of the document that was created in a previious
version of Excel I can change and create formulas.