displaying the formula not the result!

J

jimjam

New Member
Joined
Dec 5, 2005
Messages
43
Suppopse I have the following formula in a cell:

=A1&"test"

Where A1 contains a numerical value- this works fine when i type in the formula and press enter..However, if i then go into the cell, press F2 to see where the forumla references, it then just displays the formula as you see it above! I think this may just be a setting issue, but am having no luck. Can anyone help me please!!!?
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Sort by date Sort by votes
The formula cell is text-formatted...

Run Edit|Replace with...

Find What set to: =

and

Replace With set to: =

Then activate the Replace All button.
 
Upvote 0
thanks for that- why does it not fix it if i change the format to general?
I would have thought that would fix it...
 
Upvote 0
It's been my experience that you need to do a "re-enter" ie as Aladin advised, as the format change (eg from Text to General) doesn't seem to affect the pre-existing cell contents. Another way to do achieve Aladin's suggestion is to select the column and go Data>TextToColumns and then click Finish.
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Solved
Reference formula showing instead of what I'm trying to reference
Replies
3
Views
166
Fluff
Fluff
X
  • Question
Formula bar displaying SUM formula, but not its arguments
Replies
4
Views
251
KRice
K
Y
  • Question
How to delete contents of all cells with a formula that results in an empty space
Replies
7
Views
544
yslguru
Y
C
  • Question
Vlook Up not recognising Numbers
Replies
5
Views
317
Peter_SSs
Peter_SSs
R
  • Solved
Using conditional formatting to highlight the row of a cell containing specific text.
Replies
4
Views
225
etaf
etaf

Forum statistics

Threads
1,214,565
Messages
6,120,254
Members
448,952
Latest member
kjurney

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top