Prev: Using Link Bars across sites
Next: Frontpage question
From: Bob Oso Bob on 19 Jan 2010 16:18
Hello,

I am subtracting sums of time and in some instances come across a negative
number which is displayed with #################. What is a good formula to
where if value is a negative number to display "-0" instead of "#"? For
example:
31:26 - 49:43. Currently excel dispalys #s...would like to display "-0".
Thanks.
From: Tom Willett on 19 Jan 2010 16:25
You are in the wrong newsgroup. This one is for FrontPage. Try one for
Excel.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage Since 1997
---------------------------
"Bob Oso" <Bob Oso(a)discussions.microsoft.com> wrote in message
news:3E38A4BC-C69E-4E73-8C60-EB59F7F4E9A8(a)microsoft.com...
: Hello,
:
: I am subtracting sums of time and in some instances come across a negative
: number which is displayed with #################. What is a good formula
to
: where if value is a negative number to display "-0" instead of "#"? For
: example:
: 31:26 - 49:43. Currently excel dispalys #s...would like to display "-0".
: Thanks.


 | 
Pages: 1
Prev: Using Link Bars across sites
Next: Frontpage question