To Define or Modify Data Formats

 
 
 
  1. Click the cells you want to redefine, right-click and select Data Format.
  2. Choose a data type, format, and other options.
  3. Click OK.