Re: [ExcelVBA] CSV file inconsistency

 

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@yahoo.com>
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
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 9

Visit Your Group

----------------------------------
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

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___