Thread: I WANT TO WRITE 18 DIGITS FIGURE IN A SINGLE CELL. bu i m unable.
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 I WANT TO WRITE 18 DIGITS FIGURE IN A SINGLE CELL. bu i m unable.
Juat type an apostrophe (single quote ) before your digits.
--
Gary''s Student - gsnu200852


"deva" wrote:

when i m writing 123456789123456789 in a cell. it is getting changed into
1.23457E+17. why? i want to write it without any change
Reply With QuoteReply With Quote