Formatting Numbers with the General Format in Excel

 

Have you ever typed a number in a cell, and the number appeared as a date? To Excel, dates are numbers. Luckily, it’s easy to fix by selecting the desired cells and choosing the correct format from the Home tab on the Ribbon or from the Format Cells dialog box.

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

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

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

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. And I have a PowerPoint Facebook page devoted just to PowerPoint!

From Formatting Numbers with the General Format in Excel page.

Applies to Excel/PowerPoint 2007 and 2010

Kathy

 

Related posts:

Share

About Kathy

I love being involved in education because I am always learning something new and exciting. I have been teaching and helping students for over 25 years with computer applications and keyboarding classes. Before computers, I helped students learn how to use dedicated word processors. It was a long time ago! Currently, I work at MiraCosta College, a community college in California, where I teach computer applications for the Computer Applications Department and keyboarding classes for the Business Office Technology Department. I teach one- and two-day computer courses through Community Services, and work as an Instructional Assistant II for the Academic Information Services Department. I’ve been enjoying my jobs at MiraCosta for over 20 years! Prior to MiraCosta, I worked at Eldorado Business College teaching word processing and business courses. And, for about 15 years I’ve been teaching online courses (PowerPoint 2010, 2007, & 2003, and Keyboarding) through Education to Go, a division of Cengage Learning. I find teaching and learning online an awarding experience. I enjoy reading, learning, traveling, and spending time with my family. Kathy

, , ,

No comments yet.

Leave a Reply