View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Number Precision

Hope This Helps:
http://www.cpearson.com/excel/rounding.htm

Regards,
Ryan---

--
RyGuy


"yagna" wrote:

Hi All,

Could you please let me know how to increase the number precision in Excel
workbook. I'm aware that the limit is 15,but unfortunately I have more than
16 number to type in a cell.

for eg: 1234567891234565 this number will turnout to be 1234567891234560

could you please help on this excluding writing in text format.

thanks in advance,
yagna