Importing flat file into excel-sign and decimal problems

C

Candace

I'm trying to import a flat file into excel, but am having problems because
of the way my flat file displays a currency value.

example

12345+ (actual number value is 123.45)
56789- (actual number value is 567.89)

I've tried turning on the fixed decimal place =2, but it doesn't work on the
data that is being imported. Only on manual entered numbers.

Also, the + sign is giving me problems. The text import wizard allow the
trailing minus for negative numbers, but doesn't address the plus.
Therefore, my positive numbers are coming in as text.

Any suggestions without retyping the numbers?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top