Hi Hilary Lomotey
you have Custom Cell Formatting
_(* #.##0,00_);_(* (#.##0,00);_(* "-"??_);_(@_)
you must change by:
_(* #.##0,00_);_(* (#.##0,00);_(* ""??_);_(@_)
or another of your choice
Chilexcel
2012/7/31 Hilary Lomotey
> thanks Dave
>
>
> On Tue, Jul 31, 2012 at 12:48 PM, David Grug
thanks Dave
On Tue, Jul 31, 2012 at 12:48 PM, David Grugeon wrote:
> You have a circular reference. The formulas in col W refer to a range
> including the cell B34 which refers to cells in col W.
>
> I don't really understand quite what you are doing so I do not offer a
> solution but I hope thi
You have a circular reference. The formulas in col W refer to a range
including the cell B34 which refers to cells in col W.
I don't really understand quite what you are doing so I do not offer a
solution but I hope this will help you find one for yourself.
Regards
David Grugeon
On 31 July 2012
Hello Again,
There is something funny going on in the formula in the attached sheet. in
column B34 i have written a
formula INDEX($W$3:$W$667,MATCH(U3,$V$3:$V$667,0)) to pick up the value
from a list however the outcome comes with a dash (-), however if i run
formula evaluator, you can see it pick