Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Discussion (Misc queries) | |||
Saving as Text (tab delimited) surrounds text with "quotes" | Excel Discussion (Misc queries) | |||
Paste comma delimited text into a spread sheet | Excel Discussion (Misc queries) | |||
making a number be text | Excel Worksheet Functions |