Pretty simple question, need to divide whole workbook by 100, any idea

[gnibbles]

As stated in subject line, I need to divide the whole workbook by 100 to get my desired result. Will I need to start a macro? or can this be done with existing functions? Im not macro efficient either so any help would be appreciated. Thanks.

gnibbles
nturpin@excite.com

 

[SkipVought]

Hi,

Copy a cell containing 100

Select the cells that you want to divide by 100

Edit/PasteSpecial - Select Operation Divide Option



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[gnibbles]

I dont get the option to select Operation divide, all i get is "paste as unicode" or text

gnibbles
nturpin@excite.com

 

[SkipVought]

Copy a cell containing 100. You cannot copy from another application.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884