Thread: how to display cell value in formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default how to display cell value in formula
Not sure I fully understand but how about this in C1

=A1 &"*"& B1&" = "&A1*B1

Mike

"harshu444" wrote:

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

Reply With QuoteReply With Quote