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...
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.
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.
  • kboyer's avatar
    kboyer
    Copper Contributor
    May 29, 2020
    Thank you! Saved me a lot of time.

Resources