View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
 
Posts: n/a
Default How can i write a fomula?

i've try that and with the cell columns and row #'s but all i get as an answer is 1E+51 <

Hi MP440,

Right-click the cell, choose Format Cells, and then in the Category
listbox choose Number. Change decimal places to 0 if desired. Click
okay. Widen the column until you see:

10000000000000000000000000000000000000000000000000 00


Good Luck,

Greg