Forum Home
Press F1
Thread ID: 19804	2002-05-23 03:44:00	MS Excel ? (red) versus minus in red	Guest (0)	Press F1

Post ID	Timestamp	Content	User
50298	2002-05-23 03:44:00	I have reloaded all my software after finally doing a 'normal' reformat of the hard drive but now MS Excel does not let me format (a cell) so that negative mumbers are shown in brackets (and in red) - only the minus sign is offered How can I 'fix' this ? I used to have this available in the normal format , number choices but cannot see it anywhere .... please help	Guest (0)
50299	2002-05-23 04:36:00	Try format - cells - number - custom Choices should be there, if not here is one option that you could paste in there. #,##0_);[Red](#,##0) Cheers TW	Guest (0)
50300	2002-05-23 06:02:00	Wonderbar Great - thanks a million PS: I couldn't copy and paste it but was able to create a new 'Custom' format by highlighting and existing Custom format and amending it to your recomendation in the 'Type:' field ... and now it's there for future use	Guest (0)
1