View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default "$" command will not work in VISTA

Hi
Try it this way =$B$1+$B$2
HTH
John
"sjwillow" wrote in message
...
Hello,

Does anyone know why the "$" command will not work in formulas when running
VISTA? Does anyone have a solution?

A simple version of my problem is:

=$b1+$b2

When you drag down the formula in a column, it will continue to auto fill
with the next number despite the stop function "$" and will look like:

=$b2+$b3
=$b3+$b4
and so on


Any help would be greatly appreciated.

--