Thread: H E L P -Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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