Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste problem with =Proper function
The cells in column A contain:
A Fistful of Goats A Goat at the Opera A goat called Wanda A Goat Grows in Brooklyn A Goat of their Own a Goat runs through it A Goat to Remember I type =proper(a1) in B1 and the result is 'A Fistful of Goats'. When I copy the function in B1 and paste it into B2 to B7, the result (in all of the cells) is 'A Fistful of Goats". However, the cell references in B2 thru B7 are correct: =PROPER(A2) =PROPER(A3) =PROPER(A4) =PROPER(A5) =PROPER(A6) =PROPER(A7) How can I resolve this problem? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste problem with =Proper function
The cells in column A contain:
A Fistful of Goats A Goat at the Opera A goat called Wanda A Goat Grows in Brooklyn A Goat of their Own a Goat runs through it A Goat to Remember I type =proper(a1) in B1 and the result is 'A Fistful of Goats'. When I copy the function in B1 and paste it into B2 to B7, the result (in all of the cells) is 'A Fistful of Goats". However, the cell references in B2 thru B7 are correct: =PROPER(A2) =PROPER(A3) =PROPER(A4) =PROPER(A5) =PROPER(A6) =PROPER(A7) How can I resolve this problem? I'm getting this: A Fistful Of Goats A Goat At The Opera A Goat Called Wanda A Goat Grows In Brooklyn A Goat Of Their Own A Goat Runs Through It A Goat To Remember I did this 2 ways and got the same results; 1st way: select B1:B7 type =proper(a1) hit Ctrl+Enter to populate the selection with the formula 2nd way: select C1 type =proper(a1) hit Enter drag down to C7 Perhaps you should save your work, quit Excel, then restart Excel and try again. If that fails then reboot and start with a clean cache! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste problem with =Proper function
When I click F2 and press "Enter", the result in THAT cell changes to the expected (i.e., correct) result.
or when I save the spreadsheet, the results in ALL cells change to the expected (i.e., correct) results. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste problem with =Proper function
Hi,
Am Sun, 10 Jun 2018 09:41:10 -0700 (PDT) schrieb GARYWC: When I click F2 and press "Enter", the result in THAT cell changes to the expected (i.e., correct) result. or when I save the spreadsheet, the results in ALL cells change to the expected (i.e., correct) results. your calculation is set to "Manuell" Regards Claus B. -- Windows10 Office 2016 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste problem with =Proper function
Solved!
The Workbook settings was "Manual. Recalculate before saving" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and paste problem in vb | Excel Discussion (Misc queries) | |||
Copy and Paste Problem | Excel Programming | |||
copy paste problem? | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Copy/Paste Problem | Excel Programming |