Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 301
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,047
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 82
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If the result of a formula is negative make equal to zero Nrippe New Users to Excel 5 June 12th 06 10:39 PM
Ignore a cell used in a formula if it contains a negative value Donald Thomas Excel Discussion (Misc queries) 2 February 19th 06 03:18 AM
Need help with formula to give 0 if value is negative or answer is Sharona77 Excel Worksheet Functions 0 February 1st 06 09:41 PM
Formula to make Negative Values Positive & Positive Values Negative? mustard Excel Discussion (Misc queries) 4 September 26th 05 10:05 PM
formula returns (correctly) a negative value brit64 Excel Discussion (Misc queries) 5 September 19th 05 08:56 AM


All times are GMT +1. The time now is 08:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"