software

I'm using =CONCATENATE(g40,g41) and that is what is displayed in the cell.
I'm not getting the combined text strings from cells g40 and g41. When
setting up the function arguments, the expected results are shown, but when I
click quot;goquot; the spreadsheet doesn't display the correct result. I've tried
just using text instead of cell numbers and I get the same results.

Thanks.It sounds like the cell is formatted as text. Use Format | Cell |
Number (tab) and change it to General. Double-click in the cell (as if
to edit it) then press lt;entergt;.

Incidentally, you can reduce typing by changing your formula to:

= G40 amp; G41

It means the same thing.

If this doesn't cure it, you probably have the calculation mode set to
manual. Press F9 to re-calculate at any time. To change to automatic
calculation go to Tools | Options | Calculation (tab) and select
automatic.

Hope this helps.

Pete
Do you mean that the cell just shows the actual formula?

If so select cell and use

EDIT gt; REPLACE

and replace = with =

BTW a simpler formula is

=G40amp;G41--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=504235or maybe you have the wrong view, check Toolsgt;Optionsgt;View and ensure that
Formulas is not checked.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Petequot; gt; wrote in message ups.com...
gt; It sounds like the cell is formatted as text. Use Format | Cell |
gt; Number (tab) and change it to General. Double-click in the cell (as if
gt; to edit it) then press lt;entergt;.
gt;
gt; Incidentally, you can reduce typing by changing your formula to:
gt;
gt; = G40 amp; G41
gt;
gt; It means the same thing.
gt;
gt; If this doesn't cure it, you probably have the calculation mode set to
gt; manual. Press F9 to re-calculate at any time. To change to automatic
gt; calculation go to Tools | Options | Calculation (tab) and select
gt; automatic.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
Thanks. I cut and pasted what you had below and it worked. Just for fun I
re-entered =CONCATENATE(g40,g41) and it worked too!

quot;Petequot; wrote:

gt; It sounds like the cell is formatted as text. Use Format | Cell |
gt; Number (tab) and change it to General. Double-click in the cell (as if
gt; to edit it) then press lt;entergt;.
gt;
gt; Incidentally, you can reduce typing by changing your formula to:
gt;
gt; = G40 amp; G41
gt;
gt; It means the same thing.
gt;
gt; If this doesn't cure it, you probably have the calculation mode set to
gt; manual. Press F9 to re-calculate at any time. To change to automatic
gt; calculation go to Tools | Options | Calculation (tab) and select
gt; automatic.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;