ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using = (equal) (https://www.excelbanter.com/excel-discussion-misc-queries/235158-using-%3D-equal.html)

Jimmer

Using = (equal)
 
Both cells C2 and B3 are formatted for text.
Cell C2 contains June 30, '
In cell B3 I type =C2
Instead of B3 containing June 30, it contains =C2
I often use the = command from one page to another as well as on the same
page of a worksheet. This has never happened before. Using Offfice 2007.

Victor Delta[_2_]

Using = (equal)
 
"Jimmer" wrote in message
...
Both cells C2 and B3 are formatted for text.
Cell C2 contains June 30, '
In cell B3 I type =C2
Instead of B3 containing June 30, it contains =C2
I often use the = command from one page to another as well as on the same
page of a worksheet. This has never happened before. Using Offfice 2007.


Click in cell B3 and press enter... Should do the trick.

V


Jacob Skaria

Using = (equal)
 
Format B3 to general.
Press F2 in B3.
Press enter

If this post helps click Yes
---------------
Jacob Skaria


"Jimmer" wrote:

Both cells C2 and B3 are formatted for text.
Cell C2 contains June 30, '
In cell B3 I type =C2
Instead of B3 containing June 30, it contains =C2
I often use the = command from one page to another as well as on the same
page of a worksheet. This has never happened before. Using Offfice 2007.



All times are GMT +1. The time now is 07:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com