"Chip Pearson" wrote in message
...
Change file from CSV to txt (change the file extension from .csv to
.txt) and use the Import Text tool to import the file. This will allow
you to specify the formatting of the problematic values.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Wed, 26 Nov 2008 20:53:32 -0000, "Rich"
wrote:

Hi,

The team at work have to export a file from an app one column which
contains
16 digits product codes. The app only exports as a CSV. My colleagues use
excel to open the csv, but the long number reverts to scientific notation,
and formatting the cell to number corrupts the number slightly.

The only work around I can offer if to rename the CSV as text, open with
excel then go through the wizard and set the offending column to text,
which
works, but is over complicated and cumbersome for the team.

Can anyone offer an easy solution or a macro method to ease this process ?


Thanks Chip,

The users already have this solution, it's not really what they're looking
for, as it involves too many steps, I was looking for something that won't
scare excel beginners.
--
Rich
http://www.richdavies.com
http://www.richdavies.com/excel.htm
http://www.richdavies.com/fantasy-football.htm



** Posted from http://www.teranews.com **