Thread: How to restrict zeros in a number from 16th digit onwards
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vinod[_2_] Vinod[_2_] is offline
external usenet poster
  
Posts: 72
Default How to restrict zeros in a number from 16th digit onwards
How to restrict zeros in a number from 16th digit onwards.

In other wards I made cell format as "Number" with no decimals. I entered a
number in that particular cell with 1234567891234567 (16 digit number) after
enter key it converting as 1234567891234560 ( "0" at 16 digit)

Advanced Thanks,

Regards,
Vinod
Reply With QuoteReply With Quote