How do I stop (1) from turning into -1.
B bj Sep 30, 2005 #3 if you want it to remain numeric <fromat><cell><number> Select custom #,##0;(#,##0)