SOLVED

Trailing Minus

%3CLINGO-SUB%20id%3D%22lingo-sub-1412992%22%20slang%3D%22en-US%22%3ETrailing%20Minus%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1412992%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20change%20number%20values%20that%20were%20entered%20into%20Excel%2C%20not%20being%20imported%20from%20another%20data%20source%2C%20from%20being%20shown%20in%20the%20cell%20as%20-1.00%20to%201.00-.%26nbsp%3B%20I%20have%20attempted%20to%20format%20the%20cells%20to%20text%20and%20utilize%20the%26nbsp%3BText%20to%20Columns%20tool%20and%20selecting%20the%20advanced%20options%26nbsp%3Band%20clicking%20the%26nbsp%3BTrailing%20minus%20for%20negative%20numbers.%26nbsp%3BThis%20did%20not%20achieve%20the%20result%20I%20was%20looking%20for.%20I%20feel%20like%20there%20is%20another%20really%20easy%20way%20to%26nbsp%3Bchange%20the%20position%20of%20the%20minus%20sign%2C%20I%20just%20can't%20think%20of%20it.%26nbsp%3B%20I%20have%20to%20copy%20and%20paste%20the%20data%20from%26nbsp%3BExcel%20into%20an%20archaic%20system%26nbsp%3Band%20sometimes%20I'm%20looking%20at%20hundreds%20of%20numbers%20I%20have%20to%20change%20once%20I%20paste%26nbsp%3Bthe%20data%20in%20the%20other%20system.%26nbsp%3B%20Please%20help!%3C%2FP%3E%3CP%3EThank%20you%26nbsp%3Bfor%20all%20ideas.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1412992%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1413044%22%20slang%3D%22en-US%22%3ERe%3A%20Trailing%20Minus%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1413044%22%20slang%3D%22en-US%22%3EPerhaps%20try%20setting%20up%20a%20helper%20column%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3DTEXT(A1%2C%220.00%3B0.00-%22)%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20don't%20want%20the%20decimals%2C%20then%20use%20%220%3B0-%22%20for%20the%20second%20argument.%3CBR%20%2F%3ECopy%20the%20formula%20down%20the%20column.%20Then%20select%20the%20helper%20column%20and%20copy%2Fpaste%20special%20-values.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1425641%22%20slang%3D%22en-US%22%3ERe%3A%20Trailing%20Minus%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1425641%22%20slang%3D%22en-US%22%3EThank%20you!%20Saved%20me%20a%20lot%20of%20time.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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. 

2 Replies
Highlighted
Best Response confirmed by kboyer (New Contributor)
Solution
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.
Highlighted
Thank you! Saved me a lot of time.