how to do this, is it possible?


example:

field (a2) = 1*2+2*2

will show 1*2+2*2


field (a4) = auto show answer of a2

will show 6




someone help me?
thanks!


sorry if I post wrong place.

er, there's a formula view mode in excel, isn't it ?

actually i also not sure
i m excel newbie

as i know, it cannot.. either u want to show all formulae or show all answer only

but..

can teach me how to do it

eh, the problem with formula view is it is either formula or answer for the whole workbook

we should see why your need for it first, maybe there's another alternative

i post a pic

hope any1 can understand

thanks

Usually in excel, each number should be in different cells.
Or else the answer will come out as "6" on that cell.
But I know you know that also.

For your case, if you wanna show "1*2+2*2" for the sake of displaying, I dun think excel can calculate that.
If can I also wanna know how to do it.

I thought the calculation will be made if you put "=" infront of the formula?

Like: "=1*2+2*2"

You may write a function behind macro to calculate the value
when the A2 data has been change.

Technique. set A2 = text (Data without '=' sign)
A4 macro change = number (Data is combination '=' sign + A2)

Hehe...macros, something I've never bothered to learn...my loss but maybe someday I will try some simple and interesting stuff to get me going.

wrong post....

thks for ur solution

i success to do it!

but just a simple macros, is it got any improvement?????????????

macros is like this...

Sub Macro1()

Dim i As Integer

For i = 1 To 100
If Range("C" & i) <> "" Then
Set calc = Range("C" & i)
Range("E" & i) = "=" & calc
End If
Next i

End Sub


after finish to input data in C1 to c100, answer will show in E1 to E100

hello all pro can i suggest any website, because i google at website too many unwanted site come out and hard to find source.
beginner level
middle level
expert level

thank a lot

due to hard to googling..

so i post here for ask some1

if can google, no this thread anymore

yaya u r right lol so please pro suggest some site pls

Hi,

i am having a problem with excel 2007 like below



As you can see,the heading is numbers instead of the default alphabets.i tried googling but end up with nothing useful.

can anyone please guide me how to change it back to the default alphabets???