View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default convert number to money

On Sheet2 try =2*Sheet1!A1
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"lucasmhawkins" wrote in message
...
i can not figure out how to enter a numeric value and have it multiply the
number entered and transfer it to another sheet.