Forum Discussion
kboyer
May 23, 2020Copper Contributor
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...
- May 23, 2020Perhaps 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
May 23, 2020Bronze Contributor
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.
=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.
- kboyerMay 29, 2020Copper ContributorThank you! Saved me a lot of time.