Negative result gives #### is there a way to show the actual - num
in [Functions]
|
Prev: protection indicator
Next: multiplying fractions
From: Dave Peterson on 7 Mar 2010 14:14 If the cell is formatted as a time or date and the value is negative and the workbook isn't using the 1904 base date, then you can see ###'s, too. It's not always columnwidth or font size. CellShocked wrote: > > Column width or font size. Period. > > You can also then format the cell to show specifically as whole numbers > only, or define the number of digits after the decimal place you wish to > show. > > Adjust the WYSIWYG stuff like font choices and sizes, etc. after you > perfect the functional accuracy of the sheet. The printed 'report' > should be toward the end of development cycles. > > Always drag the column wider when you confront this 'problem', then > think about what 'needs' to be done to 'solve' it on a finalized sheet. > > On Sat, 06 Mar 2010 08:50:49 -0600, Dave Peterson > <petersod(a)verizonXSPAM.net> wrote: > > >Try formatting the cell as General -- or reduce the font size. > > > >And make sure the cell is not formatted as a date or time. > > > >catts22 wrote: > >> > >> Hi > >> > >> The result of a formula gives me ##### for a negative number. Is there a > >> way to get the actual negative number (i.e. for example -9 instead of ###)? > >> > >> Alternatively maybe show a 0 (zero)? Sending a report to my boss with #### > >> doesn't look so great. Maybe a minimum number formula? > >> > >> Thanks -- Dave Peterson
From: CellShocked on 7 Mar 2010 22:04
That is sad then. Should be blinking then or some other easy attribute to delineate it. On Sun, 07 Mar 2010 13:14:23 -0600, Dave Peterson <petersod(a)verizonXSPAM.net> wrote: >If the cell is formatted as a time or date and the value is negative and the >workbook isn't using the 1904 base date, then you can see ###'s, too. > >It's not always columnwidth or font size. > > > >CellShocked wrote: >> >> Column width or font size. Period. >> >> You can also then format the cell to show specifically as whole numbers >> only, or define the number of digits after the decimal place you wish to >> show. >> >> Adjust the WYSIWYG stuff like font choices and sizes, etc. after you >> perfect the functional accuracy of the sheet. The printed 'report' >> should be toward the end of development cycles. >> >> Always drag the column wider when you confront this 'problem', then >> think about what 'needs' to be done to 'solve' it on a finalized sheet. >> >> On Sat, 06 Mar 2010 08:50:49 -0600, Dave Peterson >> <petersod(a)verizonXSPAM.net> wrote: >> >> >Try formatting the cell as General -- or reduce the font size. >> > >> >And make sure the cell is not formatted as a date or time. >> > >> >catts22 wrote: >> >> >> >> Hi >> >> >> >> The result of a formula gives me ##### for a negative number. Is there a >> >> way to get the actual negative number (i.e. for example -9 instead of ###)? >> >> >> >> Alternatively maybe show a 0 (zero)? Sending a report to my boss with #### >> >> doesn't look so great. Maybe a minimum number formula? >> >> >> >> Thanks |