Thread: how to display cell value in formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
WLMPilot WLMPilot is offline
external usenet poster
  
Posts: 470
Default how to display cell value in formula
Try: =TEXT(A1,"#")&"*"&TEXT(B1,"#")

"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