View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dr Alok Modi MD Dr Alok Modi MD is offline
external usenet poster
 
Posts: 27
Default 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