Thread: Entering a 30 digit number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jay[_10_] Jay[_10_] is offline
external usenet poster
  
Posts: 2
Default Entering a 30 digit number
I want to insert a 30 digit number in a cell. When i
insert the number excel rounds it off. Is there any way i
can display the 30 digit number without it being rounded
off?
For Eg. if i enter 123456789123456789123456789 in a cell
Excel rounds it off to 1.23456789123456E+26.

Which property will I have to set if i am using an excel
object in my VB code??
Reply With QuoteReply With Quote