Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Number in Invoice | New Users to Excel | |||
From Template Save As Help | New Users to Excel | |||
Show Next Number in sequence | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions |