formating numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top