View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
T.Reisz
 
Posts: n/a
Default scientific notation

After reformatting an entire column to carry numbers with leading zeros as
text (employee data), empty cells will revert to scientific notation when new
data is input. How can I make text the default for all new data in a column?