In the CSV file, the text is simply a string of digits. If you open that
again in Excel, it will be treated as a number.
But your shouldn't create a CSV from Excel and then reopen it in Excel.
Look at the CSV file your created with a text editor. You will find that
the text numeric string is there in full, if you formatted as text before
entering the value. This means that your downstream program will get the
full information.
Regards, Dave S
----- Original Message -----
From: "Thomas" <thomas_lam_us@yahoo.com>
To: <ExcelVBA@yahoogroups.com>
Sent: Friday, June 10, 2011 8:22 AM
Subject: [ExcelVBA] Re: CSV file inconsistency
> These are 14 digits number. I format the cells to Text before entering the
> value. Then save as CSV.
>
> When I open the CSV file, the value in the column doesn't appear the same
> anymore. It is converted into an exponential number such as 9.93E+13.
>
> Strange behaviour??
>
> Regards,
> Thomas
>
> --- In ExcelVBA@yahoogroups.com, "David Smart" <smartware.consulting@...>
> wrote:
>>
>> Are these large numbers? If so, then Excel will probably not allow any
>> other approach. Please give examples of the numbers you're entering.
>>
>> However, if the numeric values are not really numbers, but are text
>> strings
>> that contain only numeric digits, then you can format the cells as text
>> BEFORE you enter the numeric values, and Excel will hopefully respect
>> that.
>>
>> Regards, Dave S
>>
>> ----- Original Message -----
>> From: "Thomas" <thomas_lam_us@...>
>> To: <ExcelVBA@yahoogroups.com>
>> Sent: Friday, June 10, 2011 7:02 AM
>> Subject: [ExcelVBA] CSV file inconsistency
>>
>>
>> >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
>> >
>> >
>> >
>> >
>> >
>> > -----
>> > No virus found in this message.
>> > Checked by AVG - www.avg.com
>> > Version: 10.0.1375 / Virus Database: 1513/3690 - Release Date: 06/09/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
>
> ----------------------------------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