It shows as 35.00 on my machine, not a problem.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"nicolasontheroad" wrote in
message ...

hello bob,

excellent, your second suggestion worked!

there is just one little problem left: numbers below 100.000 will
vanish from the sheet if this formula is applied. is it possible to
expand the formula, so e.g. 35.000 will be properly displayed?

meanwhile, thank you very much,
nic


--
nicolasontheroad
------------------------------------------------------------------------
nicolasontheroad's Profile:
http://www.officehelp.in/member.php?userid=5493
View this thread: http://www.officehelp.in/showthread.php?t=1284333

Posted from - http://www.officehelp.in