G

#### Guest

union) and I want Excel to stop storing the numbers in the column as numbers

in scientific notation. The data originally came from a flat text file which

I then converted to Excel. I'm referring to this particular column from

within another piece of software which creates barcodes. When the barcoding

software looks at this particular column, it wants to display the column data

on the barcoding label as numbers in scientific notation such as

4.357869800980E+15. First, the number was never a decimal but Excel made it

one! I'm pretty fluent in Excel and this is one of those frustrating issues

I have with Excel! I can change formats and make the number display

differently, but when it comes right down to it, they still are being read by

the barcoding software as numbers in scientific notation....something I don't

want or need. The software is displaying the number as it stored in MS

Excel...not how it is displaying!

Am I converting the flat text file the wrong way to an Excel file?