Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
negative numbers
I would like to know if there is a way to format a cell so that the number
entered into it always apppears as a negative number. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
negative numbers
"Winfield" wrote in message ... I would like to know if there is a way to format a cell so that the number entered into it always apppears as a negative number. I'm not very good at this but I tried -0 as a custom format and it seems to work. If I enter 34, it shows up as -34. Excel will still treat it as a positive number, though. So, if 34 was entered in A1 and I enter =A1+1 in a different cell with the same custom format, I get -35 /Fredrik |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
negative numbers
Problem with that format is that is also shows zero as -0, which is
nonsense, as 0 is neither positive nor negative. An alternative to show zero as 0 would be -0;-0;0 If you want thousand separators, use -#,##0;-#,##0;0 and so on -- HTH RP (remove nothere from the email address if mailing direct) "Fredrik Wahlgren" wrote in message ... "Winfield" wrote in message ... I would like to know if there is a way to format a cell so that the number entered into it always apppears as a negative number. I'm not very good at this but I tried -0 as a custom format and it seems to work. If I enter 34, it shows up as -34. Excel will still treat it as a positive number, though. So, if 34 was entered in A1 and I enter =A1+1 in a different cell with the same custom format, I get -35 /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions |