View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Man T Man T is offline
external usenet poster
 
Posts: 2
Default To display number in text format in cells

I have a sequence of digits like
5026555306553

I entered in a cell and when the cursor left the cell it displays as
5.02656E+12

How do I set the cell or the whole spreadsheet to display as text rather
than this format?