MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formatting cells

Posted by Charles on August 16, 2001 1:55 PM

Hello I am having a problem with excel in when you go to the format cells box under number and pick number or currency it should list 4 ways to show the negative data on your worksheet. A black number with a negative sign, a red number, or a black number in prentices, or a red number in prentices. For some reason my excel doesn't give me the prentices options, I've tried removing office and then reinstalling it yet nothing seems to work. Has anyone else had this problem before? Help

Posted by Richard S on August 16, 2001 3:35 PM

I've got the same problem in Excel 2000. What I've had to do is copy the format from an existing spreadsheet, and then it becomes available in that sheet only. Not sure what the problem is.