Prev: Compare between 2 worksheet
Next: Date Math
From: Otto Moehrbach on 26 May 2010 08:47 Terry That doesn't happen because you have a negative number. It's because the column is not wide enough to hold that number. Increase the width of that column. HTH Otto "catts22" <catts22(a)discussions.microsoft.com> wrote in message news:EE982E7F74EE403E965A389B4708587E(a)microsoft.com... > 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
From: Luke M on 27 May 2010 09:57 Actually, if the cell is formatted to date or time, a negative value will display hash marks. If changing column width doesn't work, try changing the cell format to General or number.  Best Regards, Luke M "Otto Moehrbach" <moehrbachoextra(a)bellsouth.net> wrote in message news:O6TMnGN$KHA.3880(a)TK2MSFTNGP04.phx.gbl... > Terry > That doesn't happen because you have a negative number. It's because > the column is not wide enough to hold that number. Increase the width of > that column. HTH Otto > > "catts22" <catts22(a)discussions.microsoft.com> wrote in message > news:EE982E7F74EE403E965A389B4708587E(a)microsoft.com... >> 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 >

Pages: 1 Prev: Compare between 2 worksheet Next: Date Math 