View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hotelmasters hotelmasters is offline
external usenet poster
 
Posts: 9
Default numbers in text format

i have downloaded a report that contains a column full of numbers that are
not recognized as numbers but rather text and can therefore not be used in
the SUM formula. the column contains over 13000 rows. is there anyway to
turn these numbers into numbers - aside from hitting F2 and enter on each and
every cell?
thanks.