why does Excel change formula to text ?

G

Guest

Hi,

Hoping someone can help :)

I've been having problems with Excel deciding that formulas should be text.
Everything goes well at first cells involved in the formula highlight in
different colours but as soon as I click the green tick it changes to text.
HELP!

I don't know if Excel is trying to second guess me as I have been cut and
pasting formulas from other workbooks with an apostrophe in front so that it
copies with no changes and then I edit the apostrophe away and the formula
works.

I have also recently changed the tick boxes in the transition tab in tools
options (can't remember which is ticked - sending this from home comp - probs
are with work comp)

TIA for any help you can offer
Many thanks
 
G

Gord Dibben

Do you mean the formulas are wiped and you just see the values?

Are you pasting your formulas from one workbook to another?

Perhaps the two workbooks are in separate instances of Excel.

Try closing one instance and open both workbooks in one instance.

Cut and copy/paste will not change the formulas to values.

Or do you mean the formula shows as a formula instead of the results?

Perhaps the cells were pre-formatted as text.

Format to General then F2 and ENTER


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace text with formula 3
Convert Text to a Formula 5
Formatting to text - apostrophe does not show 3
Why does Excel change the data I enter? 6
formula to count text entries and return text with most entries 8
VB: inserting text into a cell (excel 03) 3
when do use the & symbol in a text formula, how does it work 4
Why is Formula not calculating? 4

Top