Formatted number gets truncated when saved as tab delimited text
 

Hi,

I am experiencing an issue with number formatting and saving XLS as tab
delimited text file. One of the column in my spreadsheet has Scientific
formatting applied with 2 decimal places. When I save the file as tab
delimited text file, it saves the column data with 2 numbers after the
decimal.

Is there any way to avoid this? I need to maintain the formatting applied in
the spreadsheet, but at the same time would like to see the actual number (I
mean multiple numbers after the decimal) in the text file.

Thanks for your help and looking forward to your comments.

Prashant