Interesting. In Excel 2003, a 20 digit number, as a number, gets saved with six significant figures; as text, all sig figs, but when opened in Excel, only 15 sig figs. As expected, placing a non numeric character in the digit sequence is saved and 'restored' in Excel in the original sequence.
Dave Gathmann
--- 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
----------------------------------
Tidak ada komentar:
Posting Komentar