ExcelBanter - how do i stop sort from modifing formulas in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i stop sort from modifing formulas in excel (https://www.excelbanter.com/excel-discussion-misc-queries/141976-how-do-i-stop-sort-modifing-formulas-excel.html)

Tom & Carol

how do i stop sort from modifing formulas in excel

I am having a problem with excel 2002 I have a formula =h3-h4

=h3-h5

=h3-h6
when i sort by a differant column it changes all the formulas
--
TJS CLS

Bernard Liengme

how do i stop sort from modifing formulas in excel

Try $H$3-$H$4
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tom & Carol" wrote in message
...
I am having a problem with excel 2002 I have a formula =h3-h4

=h3-h5

=h3-h6
when i sort by a differant column it changes all the formulas
--
TJS CLS

All times are GMT +1. The time now is 07:09 PM.