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
----------------------------------
Tidak ada komentar:
Posting Komentar