Thread: I WANT TO WRITE 18 DIGITS FIGURE IN A SINGLE CELL. bu i m unable.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Trev B Trev B is offline
external usenet poster
  
Posts: 15
Default I WANT TO WRITE 18 DIGITS FIGURE IN A SINGLE CELL. bu i m unable.
You could format the cell as a Number with the correct no of Decimal Places

Trev B


"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