formating numbers

G

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?
 
S

Sandy Mann

Try a custom format of:

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

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top