No, it's not a text field (in the CSV file), it's just a string of digits.
A text field in a CSV file would presumably have quotes around it.
Regards, Dave S
----- Original Message -----
From: "Thomas" <thomas_lam_us@yahoo.com>
To: <ExcelVBA@yahoogroups.com>
Sent: Saturday, June 11, 2011 2:19 AM
Subject: [ExcelVBA] Re: CSV file inconsistency
>
> I guess the funny thing is it is a TEXT field. Why would EXCEL transform
> it to a numeric value and then reformat it to a sci notation>
> --- In ExcelVBA@yahoogroups.com, Dr John C Bullas <john.bullas@...> wrote:
>>
>> Are your numeric values large? They may be defaulting to sci notation?
>>
>> On 09/06/2011, Thomas <thomas_lam_us@...> wrote:
>> > I entered the numeric values into a new EXCEL and then save it as a CSV
>> > file. When I open the CSV file, the value in each column turn into some
>> > scientific number (Exponential number). It is not showing the same
>> > value I
>> > entered.
>> >
>> > Is there ways to prevent this from happening?
>> >
>> > Thanks for your response.
>> >
>> > Regards,
>> > Thomas
>> >
>> >
>> >
>> > ------------------------------------
>> >
>> > ----------------------------------
>> > Be sure to check out TechTrax Ezine for many, free Excel VBA articles!
>> > Go
>> > here: http://www.mousetrax.com/techtrax to enter the ezine, then search
>> > the
>> > ARCHIVES for EXCEL VBA.
>> >
>> > ----------------------------------
>> > Visit our ExcelVBA group home page for more info and support files:
>> > http://groups.yahoo.com/group/ExcelVBA
>> >
>> > ----------------------------------
>> > More free tutorials and resources available at:
>> > http://www.mousetrax.com
>> >
>> > ----------------------------------Yahoo! Groups Links
>> >
>> >
>> >
>> >
>>
>> --
>> Sent from my mobile device
>>
>> ===========================
>> http://uk.linkedin.com/in/drjohnbullas
>>
>
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search
> the ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1375 / Virus Database: 1513/3693 - Release Date: 06/10/11
>
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar