If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Remove Negative Signs from Formula Results
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Remove Negative Signs from Formula Results

#1
January 15th 08, 01:55 AM posted to microsoft.public.excel.worksheet.functions
 Holly external usenet poster Posts: 94
Remove Negative Signs from Formula Results

Hi All,

Does anyone know how to remove negative signs from formula results? This is
more than just a formatting thing as the figures need to remain positive when
a vlookup draws the data to another sheet and then when the data is imported
into another program.
--
Cheers,
Holly
#2
January 15th 08, 02:04 AM posted to microsoft.public.excel.worksheet.functions
 Tyro[_2_] external usenet poster Posts: 1,091
Remove Negative Signs from Formula Results

Multiply by -1? Or use the unary operator to change the sign? If your
formula is =2-3 which produces -1, you can do something like =-(2-3) which
produces 1. It's just elementary algebra.

Tyro

"Holly" > wrote in message
...
> Hi All,
>
> Does anyone know how to remove negative signs from formula results? This
> is
> more than just a formatting thing as the figures need to remain positive
> when
> a vlookup draws the data to another sheet and then when the data is
> imported
> into another program.
> --
> Cheers,
> Holly

#3
January 15th 08, 03:17 AM posted to microsoft.public.excel.worksheet.functions
 T. Valko external usenet poster Posts: 15,768
Remove Negative Signs from Formula Results

Put your formula inside the ABS function:

=ABS(your_formula)

--
Biff
Microsoft Excel MVP

"Holly" > wrote in message
...
> Hi All,
>
> Does anyone know how to remove negative signs from formula results? This
> is
> more than just a formatting thing as the figures need to remain positive
> when
> a vlookup draws the data to another sheet and then when the data is
> imported
> into another program.
> --
> Cheers,
> Holly

#4
January 15th 08, 03:27 AM posted to microsoft.public.excel.worksheet.functions
 Holly external usenet poster Posts: 94
Remove Negative Signs from Formula Results

Thankyou
--
Cheers,
Holly

"T. Valko" wrote:

> Put your formula inside the ABS function:
>
> =ABS(your_formula)
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Holly" > wrote in message
> ...
> > Hi All,
> >
> > Does anyone know how to remove negative signs from formula results? This
> > is
> > more than just a formatting thing as the figures need to remain positive
> > when
> > a vlookup draws the data to another sheet and then when the data is
> > imported
> > into another program.
> > --
> > Cheers,
> > Holly

>
>
>

#5
January 15th 08, 04:01 AM posted to microsoft.public.excel.worksheet.functions
 T. Valko external usenet poster Posts: 15,768
Remove Negative Signs from Formula Results

You're welcome!

--
Biff
Microsoft Excel MVP

"Holly" > wrote in message
...
> Thankyou
> --
> Cheers,
> Holly
>
>
> "T. Valko" wrote:
>
>> Put your formula inside the ABS function:
>>
>> =ABS(your_formula)
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Holly" > wrote in message
>> ...
>> > Hi All,
>> >
>> > Does anyone know how to remove negative signs from formula results?
>> > This
>> > is
>> > more than just a formatting thing as the figures need to remain
>> > positive
>> > when
>> > a vlookup draws the data to another sheet and then when the data is
>> > imported
>> > into another program.
>> > --
>> > Cheers,
>> > Holly

>>
>>
>>

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post how to remove multiple @ signs from email? mahesh New Users to Excel 1 October 20th 06 06:03 AM can I remove negative symbols without a formula PMLACC Excel Discussion (Misc queries) 4 August 25th 06 06:53 PM What is the formula to display a negative time results? Robluc65 Excel Worksheet Functions 1 October 14th 05 11:15 PM Negative Results Denise Excel Discussion (Misc queries) 2 October 7th 05 09:17 PM reversing signs - making postive a negative number mklafert Excel Worksheet Functions 4 November 29th 04 03:18 AM

All times are GMT +1. The time now is 08:10 AM.