Thread
:
Copy Problem
View Single Post
#
2
Dodo
Posts: n/a
wrote in news:1123715732.078417.170900
@g43g2000cwa.googlegroups.com:
After years of happily copying Excel formulae and/or results, I now
have a problem.
I'm copying from a worksheet saved in Excel 97. I'm working in Excel
2003. I open the saved worksheet and copy a cell such as:
=VARPA(B3:AB3)
When I paste it into a new worksheet (created in Excel 2003) the value
is pasted and not the formula.
Can anyone help me copy the formula?
Steve
What does the Number Format property show for that cell?
And if you hit F2 and Enter on that cell?
--
It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)
Reply With Quote