ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   convert number to money (https://www.excelbanter.com/excel-discussion-misc-queries/120047-convert-number-money.html)

lucasmhawkins

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.

tim m

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.


Bernard Liengme

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.





All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com