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

__._,_.___

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

Messages in this topic (5)

Recent Activity:

• New Members 8

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

.

__,_._,___