How do I import a delimited text file into Excel?
I am importing a delimited text file into an Excel 2003 spreadsheet. Everything looks great, except that my currency field is having problems. After the import, an example dollar amount is showing as 85000. When I attempt to convert this field to currency, it ends up looking like $85,000.00. It should only be $850.00. Obviously, Excel is throwing in two extra zeros. Is there anything that I can do to correct this? I'm sure it's easy, but I can't find the solution.
- thunder2sysLv 71 decade agoFavorite Answer
yeah..divide the whole column by 100.
- dphLv 41 decade ago
You aren't picking up the decimal delimiter. Start over and make sure that is checked as well as the comma, or whatever your delimiter is.
- 1 decade ago
you may download this guide and get your knowledge: