Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format
I type 93049044627327087000052. I get 9.3049E+22 in the cell. Can you please
tell me how to format the cell so I can see the whole number in cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format
Your number is so large that Excel can only display it in scientific
notation. To see the entire number as entered enter an apostrophe as the first character and follow that with your number. Excel will treat the entry as a text entry and not as a numeric one. -- Kevin Backmann "BAKERSMAN" wrote: I type 93049044627327087000052. I get 9.3049E+22 in the cell. Can you please tell me how to format the cell so I can see the whole number in cell? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format
Change the format from General to Number. With the cell selected, click
Format Cells. On the Number tab, change the category to Number. Set the number of decimal places, whether or not to show commas, then click OK. Widen the column enough to show the whole value. Hope this helps, Hutch "BAKERSMAN" wrote: I type 93049044627327087000052. I get 9.3049E+22 in the cell. Can you please tell me how to format the cell so I can see the whole number in cell? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format
But as a number that would only give 15 significant figures. To get the
rest it needs to be text, as shown in another reply. -- David Biddulph "Tom Hutchins" wrote in message ... Change the format from General to Number. With the cell selected, click Format Cells. On the Number tab, change the category to Number. Set the number of decimal places, whether or not to show commas, then click OK. Widen the column enough to show the whole value. Hope this helps, Hutch "BAKERSMAN" wrote: I type 93049044627327087000052. I get 9.3049E+22 in the cell. Can you please tell me how to format the cell so I can see the whole number in cell? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format
You're right, my bad. BAKERSMAN, please ignore my earlier reply and refer to
Kevin's. "David Biddulph" wrote: But as a number that would only give 15 significant figures. To get the rest it needs to be text, as shown in another reply. -- David Biddulph "Tom Hutchins" wrote in message ... Change the format from General to Number. With the cell selected, click Format Cells. On the Number tab, change the category to Number. Set the number of decimal places, whether or not to show commas, then click OK. Widen the column enough to show the whole value. Hope this helps, Hutch "BAKERSMAN" wrote: I type 93049044627327087000052. I get 9.3049E+22 in the cell. Can you please tell me how to format the cell so I can see the whole number in cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) |