ExcelBanter - what is this?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - what is this? (https://www.excelbanter.com/excel-discussion-misc-queries/212733-what.html)

Pierre

what is this?

i am having a problem.
i try to enter a formula in cell c1 like :
=a1/a2
but when i press enter i get this: =a1/a2
what is wrong ??

Mike H

what is this?

Hi,

2 Options

1. the cell was formatted as text
Format as general and while still in the cell tap f2 & Enter.

2. Tools|Options - view tab
Un-check 'Show formulas'.

Mike

"pierre" wrote:

i am having a problem.
i try to enter a formula in cell c1 like :
=a1/a2
but when i press enter i get this: =a1/a2
what is wrong ??

Gord Dibben

what is this?

The cell is formatted as Text or you have View Formulas enabled.

For the View Formulas hit CTRL + `(backquote above Tab key)

For the Text, re-format to General then F2 then ENTER to re-enter the
formula(s).

Gord Dibben MS Excel MVP

On Sat, 6 Dec 2008 12:01:00 -0800, pierre
wrote:

i am having a problem.
i try to enter a formula in cell c1 like :
=a1/a2
but when i press enter i get this: =a1/a2
what is wrong ??

All times are GMT +1. The time now is 03:19 PM.