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 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
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
Published by 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
View all posts by Kathy