Thread: I WANT TO WRITE 18 DIGITS FIGURE IN A SINGLE CELL. bu i m unable.
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default I WANT TO WRITE 18 DIGITS FIGURE IN A SINGLE CELL. bu i m unable.
Enter them in cells preformatted as Text or with a leading apostrophe
(').

If this post helps click Yes
---------------
Jacob Skaria


"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