I am importing a figure of 16 digits into an excel file e.g. 4000000000000002 but it is showing as 4000000000000000
Is there a way to stop this happening?
I am importing a figure of 16 digits into an excel file e.g. 4000000000000002 but it is showing as 4000000000000000
Is there a way to stop this happening?
On Sun, 9 Oct 2005 05:57:20 -0500, davee10
<[email protected]> wrote:
>
>I am importing a figure of 16 digits into an excel file e.g.
>4000000000000002 but it is showing as 4000000000000000
>
>Is there a way to stop this happening?
16 digits exceed Excel's specifications (15 digit limit).
You'll need to import the number as TEXT. Depending on exactly how you are
importing the number into the file, you might be able to preformat the cell as
TEXT; precede the value with a single quote; or specify TEXT in the
Data/Text-to-Columns wizard.
--ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks