you can use this formula also for eg your data is in row A1 and you want your
answer in row A2

=A1-2000
Then you can copy row A2 and right click on row A1 paste specialvalues.
This will replace the same row with a substracted value.
--
_______________________
Click "Yes" button if it helps
________
Thanks
Suleman Peerzade


"kav" wrote:

I want to subtract a constant number say 2000 fro an entire row and replace
the same row with the new answer