fbpx

Tag Archives | Microsoft Excel

Formatting Numbers with the General Format in Excel 2010

Notice in the example below that cells cells B2 through F2 are formatted as dates. You can verify the formatting of a cell by clicking the cell and looking at the Number Format box in the Number group on the Home tab in Excel. In the example, find the word Date in the Number Format box.

Cells B2 through F2 formatted with the Date format in Excel
Cells B2 through F2 formatted with the Date format in Excel

To change the format of the numbers (yes, dates are numbers to Excel), select cells B2 through F2; click the down arrow in the Number Format box and choose the desired format. To choose a number without any special formatting (no dollar sign or decimal places, for example), choose General as shown in the example below.

Choosing General Number Format in Excel
 Choosing the General Number Format in Excel

After formatting the numbers with the General format, your numbers will look like this:

Numbers formatted with the General format in Excel
Numbers formatted with the General format in Excel

Notice that the newly formatted numbers in cells B2 through F2 are right-aligned in each cell. Right alignment is the default format for numbers. Numbers formatted with the General format have no decimal places, commas, or dollar sign.

Have an MS Office question? Post it at my 2educateyou website or Facebook page. 

Enjoy!

Kathy

Share
Comments { 0 }