data gets rounded up !!!

I have devised a workbook where I enter the credit card details of the
transactions received at my hospital for people who pay by credit card. In
this there is one column where I enter the credit card number. This cell I
have given a general format, text format and a number format. But my tragedy
is that the last digit gets automatically rounded up. I don't understand
this. What do I do ?

Thanks

Dr Alok Modi MD

Hi

A number can only have 15 digits in Excel.
Precede the entry with a single quote to force it to be text, or
pre-format the cells as text BEFORE entering the CC number.

--
Regards

Roger Govier


"Dr Alok Modi MD" wrote in
message ...
I have devised a workbook where I enter the credit card details of the
transactions received at my hospital for people who pay by credit
card. In
this there is one column where I enter the credit card number. This
cell I
have given a general format, text format and a number format. But my
tragedy
is that the last digit gets automatically rounded up. I don't
understand
this. What do I do ?

Thanks

Dr Alok Modi MD

Try creating a custom number format... if it's always 12 digit credit card
numbers try

####-####-####-####

or if you don't want the dashes just type # 12 times...

############


"Dr Alok Modi MD" wrote:

I have devised a workbook where I enter the credit card details of the
transactions received at my hospital for people who pay by credit card. In
this there is one column where I enter the credit card number. This cell I
have given a general format, text format and a number format. But my tragedy
is that the last digit gets automatically rounded up. I don't understand
this. What do I do ?

Thanks

Dr Alok Modi MD

Pre-format cells as Text, or precede with aspostrophe.


"Dr Alok Modi MD" wrote:

I have devised a workbook where I enter the credit card details of the
transactions received at my hospital for people who pay by credit card. In
this there is one column where I enter the credit card number. This cell I
have given a general format, text format and a number format. But my tragedy
is that the last digit gets automatically rounded up. I don't understand
this. What do I do ?

Thanks

Dr Alok Modi MD

whoops, i forgot 4 * 4 = 16... should still work though

"AKphidelt" wrote:

Try creating a custom number format... if it's always 12 digit credit card
numbers try

####-####-####-####

or if you don't want the dashes just type # 12 times...

############


"Dr Alok Modi MD" wrote:

I have devised a workbook where I enter the credit card details of the
transactions received at my hospital for people who pay by credit card. In
this there is one column where I enter the credit card number. This cell I
have given a general format, text format and a number format. But my tragedy
is that the last digit gets automatically rounded up. I don't understand
this. What do I do ?

Thanks

Dr Alok Modi MD

No sixteen digits is one more digit than 15, and
15 is the maximum in digits if Excel. You cannot
use a number format, and will have to enter
the identification as a text entry as previously
stated.


"AKphidelt" wrote in message ...
whoops, i forgot 4 * 4 = 16... should still work though

"AKphidelt" wrote:

Try creating a custom number format... if it's always 12 digit credit card
numbers try

####-####-####-####

or if you don't want the dashes just type # 12 times...

############


"Dr Alok Modi MD" wrote:

I have devised a workbook where I enter the credit card details of the
transactions received at my hospital for people who pay by credit card. In
this there is one column where I enter the credit card number. This cell I
have given a general format, text format and a number format. But my tragedy
is that the last digit gets automatically rounded up. I don't understand
this. What do I do ?

Thanks

Dr Alok Modi MD

"Roger Govier" wrote:

Hi

A number can only have 15 digits in Excel.
Precede the entry with a single quote to force it to be text, or
pre-format the cells as text BEFORE entering the CC number.

--
Regards

Roger Govier


"Dr Alok Modi MD" wrote in
message ...
I have devised a workbook where I enter the credit card details of the
transactions received at my hospital for people who pay by credit
card. In
this there is one column where I enter the credit card number. This
cell I
have given a general format, text format and a number format. But my
tragedy
is that the last digit gets automatically rounded up. I don't
understand
this. What do I do ?

Thanks

Dr Alok Modi MD


Thanks all of you, I did custom format as you have mentioned, I did text format, nothing works. Don't laugh at me when I say that text format does not work, Can I upload the file so you guys can see for yourself ?

Thanks
Dr Alok Modi MD

Hi

Applying a format after you have entered data, will not change the data
in the cell. You would need to re-enter the values.

If you format a cell as Text, then enter 01234567890123456 it will take
all 16 digits and will retain leading zeros.

--
Regards

Roger Govier


"Dr Alok Modi MD" wrote in
message news


"Roger Govier" wrote:

Hi

A number can only have 15 digits in Excel.
Precede the entry with a single quote to force it to be text, or
pre-format the cells as text BEFORE entering the CC number.

--
Regards

Roger Govier


"Dr Alok Modi MD" wrote in
message ...
I have devised a workbook where I enter the credit card details of
the
transactions received at my hospital for people who pay by credit
card. In
this there is one column where I enter the credit card number. This
cell I
have given a general format, text format and a number format. But
my
tragedy
is that the last digit gets automatically rounded up. I don't
understand
this. What do I do ?

Thanks

Dr Alok Modi MD


Thanks all of you, I did custom format as you have mentioned, I did
text format, nothing works. Don't laugh at me when I say that text
format does not work, Can I upload the file so you guys can see for
yourself ?

Thanks
Dr Alok Modi MD

Thanks but I have done all that. See for eg if I were to enter a credit card
number 1234 1234 1234 1234 it gets entered as 1234 1234 1234 1230. Even if
the credit card number were 1234 1234 1234 1237 it would still get entered as
1234 1234 1234 1230. Excel rounds the last digit as zero no matter if the
last digit of the credit card number that you enter is less than five or
greater than five. Please help me as my work has come to a standstill and I
can't work this problem out . I am sure this is a useful question as this
problem would be common to many other users of excel.


Dr Alok Modi MD

Not if you enter the number preceded by an apostrophe which Excel reads as
anything following is text

'1234 1234 1234 1234

Or pre-format the cell(s) as Text.


Gord Dibben MS Excel MVP

On Mon, 14 May 2007 19:28:39 -0700, Dr Alok Modi MD
wrote:



Thanks but I have done all that. See for eg if I were to enter a credit card
number 1234 1234 1234 1234 it gets entered as 1234 1234 1234 1230. Even if
the credit card number were 1234 1234 1234 1237 it would still get entered as
1234 1234 1234 1230. Excel rounds the last digit as zero no matter if the
last digit of the credit card number that you enter is less than five or
greater than five. Please help me as my work has come to a standstill and I
can't work this problem out . I am sure this is a useful question as this
problem would be common to many other users of excel.


Dr Alok Modi MD