Re: MISSING ZERO IN IMPORTED EXCEL DATA 104.10 = 104.1 ????HOW CAN

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You're right, My VB App converts the numeric data into text because I need to
use the numeric data to locate a specific file, so the file handler requires
"text" data. So I wrote a patch in that app that gets me around that
problem.

Thanks for your help and input.

"MadHungarian" wrote:

> Even when I set the Access field to 2 decimal places, it still shows only
> one. I'm using that field in a visual basic data form and it does not
> recognize a .1 to mean .10 . I worked around the problem, but still would
> like to know how to get Access to display the full decimal place.
>
> Thanks
>
> "Nikos Yannacopoulos" wrote:
>
> > When importing from Excel (or any other external file format, for that
> > matter), Access imports values, not formats. In reality it does not lose
> > any real information, since 104.10 = 104.1, right? Now, how you show
> > data in Access, is a different subject, and that's what you are talking
> > about: formatting. Wherever you want to show the two decimals (or
> > whatever), just apply the format that you want, be it on a form or
> > report control, or even a table field (though tables are not meant for
> > displaying, entering or editing data).
> >
> > Need any more specific help?
> >
> > Nikos
> >
> > MadHungarian wrote:
> > > When I import numeric data from excel spreadsheet formatted as numeric with 2
> > > decimal places, any data where the decimal ends in 0 is missing,,,ie 104.10
> > > in excel shows up as 104.1 in access. I need the data to be in complete
> > > terms for an external program to use the data.
> >
.

Relevant Pages

  • Re: Format issue ... 2 decimal places displayed?
    ... --in the format property delete everything ... Jeanette Cunningham wrote: ... to get sql of your query, open the query in design view, then select ... release the cursor and the 2008 ('without decimals') shows up in the ...
    (microsoft.public.access.forms)
  • Re: Format issue ... 2 decimal places displayed?
    ... Jeanette Cunningham wrote: ... I've finally been able to reproduce that format with 2 decimal places in a combo on the form. ... to get sql of your query, open the query in design view, then select Query | SQL view from the menu. ... release the cursor and the 2008 ('without decimals') shows up in the text ...
    (microsoft.public.access.forms)
  • Re: SUMPRODUCT formula using hours:minutes
    ... These are numbers with decimals. ... which is used to separate hours from minutes in an Excel time format. ... or can I fix it all on the payroll sheet with the macro? ...
    (microsoft.public.excel.misc)
  • Re: Page totals error in report - doesnt add correctly
    ... Thanks Marshall - it works fine now using CDblwhen I set the format ... display it on a form or report. ... and restrict the value to 2 decimals). ... All Totals text boxes properties are set to General number with 2 decimal ...
    (microsoft.public.access.reports)
  • Re: Text changes after .........
    ... -If the Value has decimals, then the Value is only in so-called U.S. format. ... data type and then use CCur to convert ... it is usual to use the TextBox's Validate event rather than its ...
    (microsoft.public.vb.general.discussion)