| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
make cell entries a negative number
I have a situation where I would like the number entered into
a cell to always be a negative number. Seems like it should be easy but I can't seem to get it. Any suggestions? gls858 |
|
#2
|
|||
|
|||
|
if you use the negative of the absolute value
=-ABS(B32) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "gls858" wrote in message ... I have a situation where I would like the number entered into a cell to always be a negative number. Seems like it should be easy but I can't seem to get it. Any suggestions? gls858 |
|
#3
|
|||
|
|||
|
David McRitchie wrote:
if you use the negative of the absolute value =-ABS(B32) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "gls858" wrote in message ... I have a situation where I would like the number entered into a cell to always be a negative number. Seems like it should be easy but I can't seem to get it. Any suggestions? gls858 Ahhh that would work wouldn't it! That thought obviously never occurred to me :-) Thanks David, gls858 |
|
#4
|
|||
|
|||
|
If you are depending on others to enter only negative numbers, you can set
up Data Validation to accept only negative numbers in that cell, and provide an error message to remind users as well. Vaya con Dios, Chuck, CABGx3 "gls858" wrote in message ... I have a situation where I would like the number entered into a cell to always be a negative number. Seems like it should be easy but I can't seem to get it. Any suggestions? gls858 |
|
#5
|
|||
|
|||
|
CLR wrote:
If you are depending on others to enter only negative numbers, you can set up Data Validation to accept only negative numbers in that cell, and provide an error message to remind users as well. Vaya con Dios, Chuck, CABGx3 "gls858" wrote in message ... I have a situation where I would like the number entered into a cell to always be a negative number. Seems like it should be easy but I can't seem to get it. Any suggestions? gls858 Thanks Chuck. I'll give your solution a try also. gls858 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| How can I make a cell a certain color dependent on number value? | Excel Discussion (Misc queries) | |||
| Equation Referencing Row Number Stored in Cell | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
Linear Mode
