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

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

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