data gets rounded up !!!
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
|