Inputting numbers to be read as a negative number

[Michael1105]

Is there a way to format a column of cells to automatically convert the inputted numbers as a negative number?  I have looked in the Format Cell feature and the only options are for to display a negative number with the minus sign, in red with the minus sign, etc.  I need for the cell to display the inputted number and value that number in the negative....  This may seem like an easy function to do but I can't find the answer in the Help sections of Excel.  I appreciate any help!

[#2]

Hello @Michael1105,

To make a value appear as a negative number, go into Custom Formats and enter -0. I must warn you, however, that this only changes the appearance of a value to be negative.

If you truly wish to change a value to be negative, then I suggest creating a helper column with a formula such as =-ABS(A1).

[#3]

Thank you so much!  You are a godsend!

[#4]

@Michael1105 

Paste special | multiply by -1

[#5]

@Patrick2788 Thank you...PReagan answered exactly what I needed.  I appreciate your help.  You have helped me immensely through this project I am doing. 

[#6]

@Michael1105 

Glad to help!