Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert number to money
i can not figure out how to enter a numeric value and have it multiply the
number entered and transfer it to another sheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert number to money
Can you not put the multiplier in the other sheet?
for example if you enter the number 25 in A1 of sheet1 and want to have it multiplied by 10, put this formula in your 2nd sheet. =Sheet1!A1*10 "lucasmhawkins" wrote: i can not figure out how to enter a numeric value and have it multiply the number entered and transfer it to another sheet. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should have a formula to convert number into words | Excel Worksheet Functions | |||
How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)? | Excel Discussion (Misc queries) | |||
Convert [h]:mm sum total format to number format | Excel Worksheet Functions | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
"Convert to Number" option disappearing | Excel Discussion (Misc queries) |