Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I remove negative symbols without a formula
I have negative #'s that I want to make positive with a format rather than a
formula. Is there any way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I remove negative symbols without a formula
Negative numbers DISPLAYED as positive numbers are still negative numbers!
Apply a format such as General;General So if you SEE 3 3 and add them, if the first is "really" -3, the sum will still be 0. "PMLACC" wrote in message ... I have negative #'s that I want to make positive with a format rather than a formula. Is there any way to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I remove negative symbols without a formula
Hi,
bob is right, but if you need to change negative to positive, copy the range and paste special values and subtracting or use an auxiliar cell, type -1 copy it and paste special values and multiply hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "PMLACC" escreveu: I have negative #'s that I want to make positive with a format rather than a formula. Is there any way to do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I remove negative symbols without a formula
Not by formatting but.............
Enter -1 in a cell. Copy it. Select your range of negative numbers and Paste SpecialMultipleyOKEsc Gord Dibben MS Excel MVP On Fri, 25 Aug 2006 09:45:02 -0700, PMLACC wrote: I have negative #'s that I want to make positive with a format rather than a formula. Is there any way to do this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I remove negative symbols without a formula
If your only concern is to display negative numbers as positive, this can be
done by creating a custom number format. But I would agree with the previous posts and caution against doing this for any sheets that will involve calculation, or will be used by anyone unfamilar with the custom formating. It can be very difficult to debug a spreadsheet if the data you see is not the same as the values that are stored, as it is usually not clear to other users (or even to yourself after a few months have passed) when custom formats are in use. /* ending soapbox mode*/ The following custom format would show both positive and negative numbers without and signs (and zeros as a dash): #,##0;#,##0;"-";@ As another example, the following format would show positive values as negative and vice versa, with 'Accounting' format style aligned parentheses: (* #,##0);_(* #,##0_);_(* "-"_);_(@_) To use these, just select a number format type of 'Custom' in the Format Cells dialog box, and paste the format definintion into the 'Type' box. Custom formats can give you great flexibility in the way data is shown, but it is up to you to make sure they are used appropriately. Good luck TK "PMLACC" wrote: I have negative #'s that I want to make positive with a format rather than a formula. Is there any way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If the result of a formula is negative make equal to zero | New Users to Excel | |||
Ignore a cell used in a formula if it contains a negative value | Excel Discussion (Misc queries) | |||
Need help with formula to give 0 if value is negative or answer is | Excel Worksheet Functions | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
formula returns (correctly) a negative value | Excel Discussion (Misc queries) |