Number Formatting/Scientific notation
 

Hello,

I have a question as to the behavior of Excel when working with the following:

Open a large file in .csv formatt, formatt a column for number formatting
since the number is too long and comes up with scientific notation. I
believe if you do not save the file a million times that once you close the
file and reopen it (all in .csv files), you not only loose the number
formatting, but it strips the number out replaces the ending numbers with
zeros, leaving you with invalid numbers.

Why does this happen and how can it be avoided?

Thank you!

Number Formatting/Scientific notation
 

Format the column to show all the numbers you need

Format|Cells|number tab
Number (?? number of decimal places)

Do this before you save it as a .csv file.

Patrice wrote:

Hello,

I have a question as to the behavior of Excel when working with the following:

Open a large file in .csv formatt, formatt a column for number formatting
since the number is too long and comes up with scientific notation. I
believe if you do not save the file a million times that once you close the
file and reopen it (all in .csv files), you not only loose the number
formatting, but it strips the number out replaces the ending numbers with
zeros, leaving you with invalid numbers.

Why does this happen and how can it be avoided?

Thank you!

--

Dave Peterson