Home |
Search |
Today's Posts |
#1
|
|||
|
|||
saving exponential to text data
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 |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |