I'd been using this file for a long time without problem, but recently it became kind of wierd when I try to copy and paste the forumla.
After I copy and paste, it did copy the forumla to the new box but instead of showing the result base on the forumla, it actually copied the "actual" number as well.
For example: I tried to copy cell T76 with a formula of "=F76*1.02041" and a result 13.99 to T77, i should show a new formula of "=T77*1.02041" and a result based on that formula.
But instead, it did show the formula of "=T77*1.02041", but the result would show 13.99.
Any body know how to fix this? Please help, thanks.
2007-03-12 07:26:33 · 6 answers · asked by JT 1 in Computers & Internet ➔ Software
Sometimes a column that has been formatted as text will not revert back to a number format. Try to select the column, click Format, Cells. Choose a number format. Try to paste again.
If it still doesn't work, delete the column. Try to pate into the next column. If THAT still doesn't work, it means that the second column next to the one you deleted was also formatted as text and Excel isn't clearing it. Delete a few columns to make sure you get all the ones that may have been formatted as text.
When this happens, it's a hassle to fix.
Unnga, it seems you have launched two separate instances of Excel and you are trying to paste from one into the other.
2007-03-13 18:48:13 · answer #1 · answered by icepero 3 · 0⤊ 0⤋
When you try to copy and paste a formula, the cell numbers will still be for the previous blocks. If it's right below, then just drag the formula down, but if you need the formula at a different location, copy the formula, paste and type in the right cell numbers in the bar - that's how I've been doing it, and it works for me. Good luck.
2007-03-12 14:35:07 · answer #2 · answered by HappilyEverAfter 4 · 0⤊ 0⤋
Do a "paste special" instead of a normal "paste". You can find it in the edit menu right below the paste command. Choose "formulas" in the dialog box that appears, and the actual formula will paste over instead of the value.
2007-03-12 14:30:47 · answer #3 · answered by Corran 3 · 1⤊ 0⤋
I am having the same problem recently too. Paste special shows text dialog box instead. Still trying to find out whats wrong.
2007-03-13 14:48:29 · answer #4 · answered by unnga 6 · 0⤊ 0⤋
try using the past special option. this give you the option to past formula!
2007-03-12 14:30:00 · answer #5 · answered by unlistedid 2 · 1⤊ 0⤋
EDIT | PASTE SPECIAL | FORMULA
2007-03-12 14:29:18 · answer #6 · answered by Kokopelli 6 · 0⤊ 1⤋