Forum Home
Press F1
Thread ID: 10	1998-09-01 00:25:00	Formatting negative numbers	Guest (0)	Press F1

Post ID	Timestamp	Content	User
114	1998-09-01 00:25:00	I use Microsoft Office 95 on a Pentium- 133. Frequently, in accounting applications, brackets are entered around negative figures instead of minus signs before them. I have found no way to do this in Excel. Is it possible to do this and, if so, how? Is it possible to open in Word or Excel, in usable form, plain Ascii files that have been prepared by other applications?	Guest (0)
115	2004-12-24 01:28:00	I don't know if Excel95 supports this - I don't have it to try, but see if you can enter a custom format for the cells in question as: #.00;(#.00);0.00; The three strings (separated by semicolons) and a fourth (left blank) are the format for positive ; negative ; zero ; text entries. If you don't want 0.00 for zero to be displayed - simply change it to whatever e.g. #.00;(#.00);; or more simply #.00;(#.00) would display blank for zero.	wuppo (41)
116	2004-12-24 01:55:00	Ah wuppo - you do realise this is a very old post you have replied to. Have a look at the date. :)	Jen (38)
117	2004-12-24 02:13:00	:blush: Bugr - Hit the last page link instead of the next page link. [gives self uppercut and slinks off to sulk in the corner]	wuppo (41)
1