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...
  • JMB17's avatar
    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