Articles → EXCEL → Convert Data Format In Excel 2007

Convert Data Format In Excel 2007

Software Requirement

Prerequisite Knowledge

Open A New Excel

Add Data In Excel

Picture showing the sample excel file to be used for data format
Click to Enlarge

Change Data Format In Excel

  1. Select the column (on which you want to change data format)
  2. Select the format icon in ‘Number’ ribbon group and click on $ English (United States).
Picture showing selecting the English (United States) format
Click to Enlarge


Picture showing the excel file after formatting is applied
Click to Enlarge

Posted By  -  Karan Gupta
Posted On  -  Wednesday, May 1, 2013


Your Email Id  
Query/FeedbackCharacters remaining 250