ExcelBanter - if i put value 5001662079259011 then coming 5001662079259010

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if i put value 5001662079259011 then coming 5001662079259010 (https://www.excelbanter.com/excel-discussion-misc-queries/119587-if-i-put-value-5001662079259011-then-coming-5001662079259010-a.html)

Lalit Prajapt

if i put value 5001662079259011 then coming 5001662079259010

Bob Phillips

if i put value 5001662079259011 then coming 5001662079259010

15 digits is the max. Set the cell as text or precede with '.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Lalit Prajapt" <Lalit wrote in message
...

All times are GMT +1. The time now is 06:40 PM.