Thread: how to stop changing 15 or 16 digit of number to 0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default how to stop changing 15 or 16 digit of number to 0
Either preceed the value with a single quote when typing or format the cell
to Text before typing.
--
Gary''s Student - gsnu200840


"Nitish Sharma" wrote:

while typing 16 digit bank account number in excel sheet it 15 and 16 digit
of the same authomatically changed to 0. Please tell me how to stop the same.
Reply With QuoteReply With Quote