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.
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.
After formatting the numbers with the General format, your numbers will look like this:
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!
Kathy
This blog has inspired me to carry on working on my own blog
Hi Jane,
When you type more than 11 numbers in a cell, Excel formats the number as Scientific. So, 2.13+E51 represents the scientific number for the number you typed in the cell.
For more information about scientific numbers, check out this article:
Display numbers with scientific notation at http://office.microsoft.com/en-us/excel-help/display-numbers-with-scientific-notation-HP003064132.aspx?CTT=1
Hope this helps!
Kathy Van Pelt
i enter 2131…..40001 in a cell with general format it is displayed as 2.13+E51
I tried any way i thought.i even switched to number but then my number instead of 2131…40001 is 2131…..40000(the final 1 is changed to 0)
It is really annoyig i could not find any help on any forume