formula not replaced by value

[Babu]

Friends

Some time formula will not be replaced by values
as shown below, even after hitting 'ENTER'
What may be the reason


A B C D

+BS ^ =CONCATENATE(A1,(REPT(C1,31-
LEN(A1))),B1)
SUBID 000000000013 ^

Thank you
Babu

 

[Svetlana]

Your cell with the formula is probably formatted
as "text". Try to change it to at least general.

(Just in case: Format (menue) -> Cell... -> Number (tab) -

Select "General" from "Category")

Hope this helps,
Svetlana

 

[BrianB]

1. A formula must start with = (equals sign)
2. The formula might be written wrongly (what actually appears in th
cell ?)
3. The cell may be formatted as text - when you see the formula instea
of its value

 

[Babu]

Brian

A,B,C,D are column names
D contains the formula
I changed the format of the cell from "Text" to "General"
It starts with "="
In the dialog window value appears
not in the work sheet
Is there any other setting I've to do?
Please help, it's driving me crazy.....

Thanks
Babu

 

[Paul]

Brian

A,B,C,D are column names
D contains the formula
I changed the format of the cell from "Text" to "General"
It starts with "="
In the dialog window value appears
not in the work sheet
Is there any other setting I've to do?
Please help, it's driving me crazy.....

Thanks
Babu

Changing the format from text to general is not sufficient to change a text
string that was already in the cell into a formula. You also need to select
the cell, put the cursor in the formula bar and press ENTER.

 

[Gord Dibben]

Babu

If you are seeing the formulas and not the results, the formula cells could
have been formatted as Text prior to entering the formulas or you are in
Formula View. Tools>Options>View>Formulas. If the former, changing format to
General will not do the trick.

Select the cells with formulas showing and Edit>Replace

What: =
With: nothing

Replace All.

Gord Dibben XL2002

 

[Babu]

Gord and Brian
Thank you very much
it works now