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.