How to fix trailing minus signs in Excel?

jdixon

When I import data sometimes I get a minus sign after the number (1234-) instead of before (-1234) to display a negative value. How can I fix it so the minus sign is in front of the numbers when I import data in Excel 2013?

Topic: Software
Answer this Question

Answers

2 total
cybercop001
Vote Up (6)

If you give little more detail as from where you are importing data to excel and how, help can be given.

rcook12
Vote Up (5)

I’ve ran into this before, actually. I think it is caused by the default settings in the Advanced Text Import Settings. Anyway, there is a quick way to resolve it: 

 

A. Select the imported data that has the trailing minus signs. You can select it all, including positive values, you don’t have to just choose the ones with negative value. 

B. Select Data>Data Tools>Text to Columns.

C. In the Text to Column box that pops up, just click Finish, and it should fix it. 

 

I learned this from a book called 101 Excel Tips or something like that and still have it on a sticky note next to my desk. Hope this helps you out. 

Ask a question

Join Now or Sign In to ask a question.
Oregon has filed a long-expected lawsuit against Oracle over its role developing the state's troubled health insurance exchange website, alleging the vendor fraudulently induced Oregon to pay hundreds of millions of dollars for software and services that didn't work as promised.
It took some time and considerable internal effort, but SAP says it has made good on a pledge to simplify its software pricing and licensing model.
They're also looking to include Android, which IHS says will dominate the market.
After October, there will be no way to buy a Windows 7 PC and nothing but Live Tiles on the horizon.
Given that at least five top-flight smartphones will be launched in September, would-be buyers will have plenty of choices.
Employee says latest 'Blue Screen of Death' screw-up affects only 1 in 10,000 PCs.
Jumping into the growing NoSQL market, Microsoft has debuted a simple data store through the Azure cloud hosting service.
Most people start thinking about retirement when they turn 70, if they haven't already called it a career. Not Oracle CEO Larry Ellison, who passed that milestone Sunday.
With a Microsoft-mandated deadline a little more than two months away, computer makers are still selling PCs equipped with Windows 7 Home Premium.
Our first glimpse of Windows 9 may be right around the corner, as the new rapid-fire Microsoft scrambles to put the stigma of Windows 8's disastrous launch in the rear view mirror.

White Papers & Webcasts

Webcast On Demand

Cloud BI Overview: Jaspersoft for AWS

Sponsor: TIBCO Jaspersoft

Webcast On Demand

Cloud BI in Action: Recorded Webinar of Customer, Kony, Inc.

Sponsor: TIBCO Jaspersoft

See more White Papers | Webcasts

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

randomness