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:EE982E7F-74EE-403E-965A-389B4708587E(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:EE982E7F-74EE-403E-965A-389B4708587E(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