Forum Discussion

kboyer's avatar
kboyer
Copper Contributor
May 23, 2020
Solved

Trailing Minus

I am trying to change number values that were entered into Excel, not being imported from another data source, from being shown in the cell as -1.00 to 1.00-.  I have attempted to format the cells to text and utilize the Text to Columns tool and selecting the advanced options and clicking the Trailing minus for negative numbers. This did not achieve the result I was looking for. I feel like there is another really easy way to change the position of the minus sign, I just can't think of it.  I have to copy and paste the data from Excel into an archaic system and sometimes I'm looking at hundreds of numbers I have to change once I paste the data in the other system.  Please help!

Thank you for all ideas. 

excel
Formulas and Functions
  • JMB17's avatar
    JMB17
    May 23, 2020
    Perhaps try setting up a helper column:

    =TEXT(A1,"0.00;0.00-")

    If you don't want the decimals, then use "0;0-" for the second argument.
    Copy the formula down the column. Then select the helper column and copy/paste special -values.

2 Replies

  • JMB17's avatar
    JMB17
    Bronze Contributor
    May 23, 2020
    Perhaps try setting up a helper column:

    =TEXT(A1,"0.00;0.00-")

    If you don't want the decimals, then use "0;0-" for the second argument.
    Copy the formula down the column. Then select the helper column and copy/paste special -values.

Resources