if you want to do it with code, you'll have to break your formula down
something like this:

sub test
Range("c1").Formula = "=" & Range("A1").Value & "*" & Range("b1").Value & ""
end sub
--

Gary


"harshu444" wrote in message
...
hi guys,
my problem is this, a1 is 5, b1 is 6, c1= a1*b1, how can i
display the cell value as 5*6.
PLZ HELP