There are two types of challenges here first being inserting a minus sign in excel(or hyphen in string) and the other is inserting a negative number in a cell in excel.
If you start typing minus symbol at the beginning, excel will treat it as formula and thrown an error.
Let’s see how we could insert a minus sign “-” before a value in excel.
There are two aspects to it, one is if you have alphanumeric values in a column and you would like to insert a minus sign before the value so the resultant value is text string only.
Enter the formula below, we will just concatenate a minus sign at the beginning of the value as show below.
=”-“&A2
In the other scenario when your data is completely numeric and you want to have a minus sign before each value, just multiply them with -1 as show below.
The formula will be =-1*A2
Hope this helped.
