Thread
:
Getting rid of +/- in date subtraction..
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Mark
external usenet poster
Posts: 989
Getting rid of +/- in date subtraction..
My formula in cell c7 reads =c5-c6
If I put 01/01/2009 in c5
and 01/10/2009 in c6
I get -9 in c7
C6 will always be later than c5
Can I get rid of the (-) in c7? and have just a number?
Thanks in advance.
Mark
Reply With Quote
Mark
View Public Profile
Find all posts by Mark