![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Mar 2002
Posts: 5
|
Hi, Folks! Hope someone can help me!
Am trying to use concatenate function to two cells - the results in the function dialog box are correct as I select cells to apply the fucntion to - BUT when I click OK, the results cell contains the formula and NOT the result. I'm seeing the same thing attempting other text functions, as well! Can anyone give me an idea of why this behavior is happening? Anyone else experienced such a thing? Thanks for your assistance!! CR |
|
|
|
|
|
#2 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: Newcastle, UK
Posts: 1,174
|
Quote:
Tools/Options/View then check to see if the Formulas box is checked, it shouldn't be. Any help
__________________
"Have a good time......all the time" Ian Mac |
|
|
|
|
|
|
#3 |
|
New Member
Join Date: Mar 2002
Posts: 5
|
Ian: Thanks, but no good so far - my box is unchecked
I'm trying to see if anyone else is seeing the same nonsense. |
|
|
|
|
|
#4 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: Newcastle, UK
Posts: 1,174
|
Quote:
__________________
"Have a good time......all the time" Ian Mac |
|
|
|
|
|
|
#5 |
|
New Member
Join Date: Mar 2002
Posts: 5
|
Ian:
Thanks for the offer, but I think I've got it figured out - Excel doesn't like to concatenate numbers which have been formatted as text (i.e. zipcode data) - by using 'general' format I've fixed most problems. Thanx again! CR |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|