Remember Me?

#1
June 10th 18, 12:41 AM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Sep 2016 Posts: 79
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
June 10th 18, 03:20 AM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Apr 2015 Posts: 981
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
June 10th 18, 05:41 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Sep 2016 Posts: 79
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
June 10th 18, 05:45 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,651
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
June 10th 18, 07:38 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Sep 2016 Posts: 79
Copy/Paste problem with =Proper function

Solved!

The Workbook settings was "Manual. Recalculate before saving"

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Blubber Excel Discussion (Misc queries) 5 November 13th 08 06:54 PM Ronald W. Roberts Excel Programming 3 July 20th 08 04:00 AM Neil22 Excel Discussion (Misc queries) 5 January 10th 06 06:32 PM Asif Excel Discussion (Misc queries) 2 December 9th 05 06:16 PM Pete McCosh[_5_] Excel Programming 0 October 1st 03 05:14 PM

All times are GMT +1. The time now is 11:56 AM.