Formula
 

I would like to take a large spreadsheet and add 0.01 to each cell in it
without that being visable to others when I distribute the spreadsheet to
others?

Thanks

Formula
 

Not sure what you mean by not 'being visible'...

but to add 0.01 to all cells enter 0.01 in any unused cell
Copy the cell
press CTRL-A in the worksheet you want to select ALL
Right-click and choose Paste Special and choose ADD
Click OK
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"T-Bone" wrote:

I would like to take a large spreadsheet and add 0.01 to each cell in it
without that being visable to others when I distribute the spreadsheet to
others?

Thanks

Formula
 

in Exel 2007 when I hit "paste special", it does not have the options it had
in excel 2003...all it has is paste as unicode text or text....am I insane or
did Microsoft move that feature?

"Sheeloo" wrote:

Not sure what you mean by not 'being visible'...

but to add 0.01 to all cells enter 0.01 in any unused cell
Copy the cell
press CTRL-A in the worksheet you want to select ALL
Right-click and choose Paste Special and choose ADD
Click OK
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"T-Bone" wrote:

I would like to take a large spreadsheet and add 0.01 to each cell in it
without that being visable to others when I distribute the spreadsheet to
others?

Thanks