entering numbers in excel

[Guest]

when I tried to enter number 123456789101112,the last digit ie 15th digit
changes to 0 instead of 2.It happens with every number with morethan 14
digits.
I tried regional settings which seem ok to me.
Is there a way out to enter number as number without using the text
formatting.
vkwd7

 

[Guest]

Precede the number with a single quote (apostrophy).

 

[Don Guillett]

15 max

 

[Niek Otten]

But it will be treated as text. Excel's precision (for numbers, that is) is 15 decimal digits

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Precede the number with a single quote (apostrophy).
| --
| Gary's Student
|
|
| "vkwd7" wrote:
|
| > when I tried to enter number 123456789101112,the last digit ie 15th digit
| > changes to 0 instead of 2.It happens with every number with morethan 14
| > digits.
| > I tried regional settings which seem ok to me.
| > Is there a way out to enter number as number without using the text
| > formatting.
| > vkwd7
| >

 

[Niek Otten]

If it is a .csv file, rename it .txt
On importing, you'll get a wizard in which you can specify the field as text

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have huge spreadsheets that I am importing into excel which contain credit
| card numbers (16 digits). Is there any way to force Excel to recognize
| these?
|
| Thanks
| Lsm
|
| "Don Guillett" wrote:
|
| > 15 max
| >
| > --
| > Don Guillett
| > SalesAid Software
| > (e-mail address removed)
| > | > > when I tried to enter number 123456789101112,the last digit ie 15th digit
| > > changes to 0 instead of 2.It happens with every number with morethan 14
| > > digits.
| > > I tried regional settings which seem ok to me.
| > > Is there a way out to enter number as number without using the text
| > > formatting.
| > > vkwd7
| > >
| >
| >
| >

 

[Guest]

Thank you! This did indeed solve the problem. It is a few extra steps for
our employees, but it saves so much more. Thanks again! Has anyone out
there heard about Excel having a way to reduce credit card #s to 4 digits to
solve this problem? A co-worker said she saw this in a help file but then
could not locate it again, but it was written especially to address the
credit card number issue.