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