Yahoo Clever wird am 4. Mai 2021 (Eastern Time, Zeitzone US-Ostküste) eingestellt. Ab dem 20. April 2021 (Eastern Time) ist die Website von Yahoo Clever nur noch im reinen Lesemodus verfügbar. Andere Yahoo Produkte oder Dienste oder Ihr Yahoo Account sind von diesen Änderungen nicht betroffen. Auf dieser Hilfeseite finden Sie weitere Informationen zur Einstellung von Yahoo Clever und dazu, wie Sie Ihre Daten herunterladen.
Excel 2003 Negative Numbers?
Spurred by another question, I've just realised I cannot format negative numbers to be in brackets - the option's just not there. I'm sure it was in Excel 2000. I know HOW to do it, it's just that it appears no longer to be possible. Is it just me, or is this one of the "Improvements" in 2003?
Any thoughts much appreciated.
Thanks
3 Antworten
- **tomtomLv 5vor 1 JahrzehntBeste Antwort
You are right its confusing.
go to format,cells and custom, then you will see on the drop down menu brackets........choose that and you are sorted.
and I dont call that improvement.
- Anonymvor 1 Jahrzehnt
Just change the cell format to Accounting and the negative numbers will be in brackets.
Quelle(n): Looking at the numbers in Excel 2003 as I write this.... - Anonymvor 4 Jahren
utilizing the format will take care of the quantity as detrimental and they're going to plot that way. The abs() should be inserted in each and each cellular, making it difficult (until eventually you recognize a thanks to application it). try right here: Edit replace locate what: - replace with: that would favor to remove all the detrimental values. If there are formula, this received't artwork. Be selective on the cells you want, because that's going to remove ALL minus signs and indications (although you may %. any selection length).
