formating numbers

[GeorgeJ]

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?

 

[Sandy Mann]

Try a custom format of:

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

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk