Hi guys,
I have a minor issue which is kind of bugging me, and its to do with importing from excel into Access.
i have this number in excel:
8.5701004593e+011
Before I do anything, I do have to format this number first so: Format-> number -> remove two decimal places to make it look like the number below.
857010045930
Whenever I import into access my records show up as:
8.5701004593e+011 which doesn't make sense to my users. What can I do to make it appear as:
857010045930
Help would be appreciated
Thanks
Red
___
I have a minor issue which is kind of bugging me, and its to do with importing from excel into Access.
i have this number in excel:
8.5701004593e+011
Before I do anything, I do have to format this number first so: Format-> number -> remove two decimal places to make it look like the number below.
857010045930
Whenever I import into access my records show up as:
8.5701004593e+011 which doesn't make sense to my users. What can I do to make it appear as:
857010045930
Help would be appreciated
Thanks
Red
___