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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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 spread*** 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.
>
.

Quantcast