Try a custom format of:

###,###;-###,###;;

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"GeorgeJ" wrote in message
...
Suppose I want to format a cell such that

a) 123456 would show as 123,456

b) -123456 would show as -123,456

c) 0 would show as a blank cell


How would I do it?

--
-regards