Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
H E L P -Excel
Hello
I am trying to figure out the math on thousands of items. Want to divide the cost by .56, cant find this!! which function key to do I use?? ty |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
H E L P -Excel
There's no "function key" to divide cell values by .56.
One possibility. Enter 0.56 in an empty cell. Copy the cell. Select your thousands of items. Choose Edit/Paste Special, selecting the Values and Divide radio buttons. Click OK. In article , Ticklelish wrote: Hello I am trying to figure out the math on thousands of items. Want to divide the cost by .56, cant find this!! which function key to do I use?? ty |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
H E L P -Excel
try entering .56 in a blank cell. Right click and then copy. Highlight the
thousands of cells and right clickpaste special select values and divide and then ok. All of the cells will be divided by .56 Hope this helps "Ticklelish" wrote: Hello I am trying to figure out the math on thousands of items. Want to divide the cost by .56, cant find this!! which function key to do I use?? ty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|