A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Setting up and Configuration of Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

saving exponential to text data



 
 
Thread Tools Display Modes
  #1  
Old February 14th 05, 02:11 PM
PTL
external usenet poster
 
Posts: n/a
Default 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
Ads
  #2  
Old February 15th 05, 01:53 AM
Dave Peterson
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2004-2013 ExcelBanter.
The comments are property of their posters.