![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
I have been having aproblem saving my xl sheet to csv and keeping the text
information as text. I change the whole column to text from exponential numbers. It appears okay. Then when I save the document as a csv document it reverts back to the exponential numbers. I get numerous warnings on you will lose information by using the csv format and whether I answer yes or no to the questions the data always reverts back to exponential data and not the text data it was changed to. What am I doing wrong? -- PTL |
| Ads |
|
#2
|
|||
|
|||
|
I think the biggest thing you're doing wrong is multiposting to various
newsgroups. If you think you have to hit lots of groups, include them all in the header and send it once. You have multiple responses to your thread in .misc. PTL wrote: > > I have been having aproblem saving my xl sheet to csv and keeping the text > information as text. > > I change the whole column to text from exponential numbers. It appears > okay. Then when I save the document as a csv document it reverts back to the > exponential numbers. > > I get numerous warnings on you will lose information by using the csv format > and whether I answer yes or no to the questions the data always reverts back > to exponential data and not the text data it was changed to. > > What am I doing wrong? > -- > PTL -- Dave Peterson |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| pasting data from a website changes text to date | stebro | Excel Discussion (Misc queries) | 8 | August 12th 06 08:39 PM |
| how do I change the text case of imported data in excel? | ArtLene | Excel Discussion (Misc queries) | 1 | January 26th 05 07:08 AM |
| Pulling data from 1 sheet to another | Dave1155 | Excel Worksheet Functions | 1 | January 12th 05 05:55 PM |
| Convert data of cells to any type: Number, Date&Time, Text | Kevin | Excel Discussion (Misc queries) | 0 | December 30th 04 06:55 AM |
| VBA Import of text file & Array parsing of that data | Dennis | Excel Discussion (Misc queries) | 4 | November 28th 04 10:20 PM |