Turning off E+ format

[Aumkar]

Hello Everyone

I have huge number of data in an excel sheet. Some numbers are seen as "E+0.7" or 2.08E+0.5.

I would like to know, if there is any method to display the numbers as normal number and not like
E+

[shg]

Format those cells as Number with however many decimals you like.

[Aumkar]

I formatted those cells as number with 8 decimals, but when i try to save, it says that Filename.csv may contain features that may not be compatible with CSV.

Actually, it is a csv file and i need to import these data to another software. When i import it as it is, with E+ values, the data is not shown correctly in the software.

What can i do now to get these large numbers to be saved without E+ format?

[martindwilson]

what does it look like after saving?

[Aumkar]

It doesn't save in .csv format, it says that format is not compatible and when i save, it converts as excel workbook. In Excel workbook, it looks fine.
But, when i try to change the format as .csv, the numbers revert back to E+
I can't import the data from an excel workbook. It needs to be in .csv format.

[martindwilson]

works fine for me ,must be something else. here'a one i changed and saved what is the exact message as it appears on screen?