Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting a formula when typing long numbers
Why do i get 6.7e+09 in a cell when i tried to type in 6680344953? I know
that I can resolve this problem by changing the cell to text format but why does it happen sometimes and not other times? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting a formula when typing long numbers
6.7e+09 is 6.7*10^9, that is, scientific notation. Try widening the column
or else clicking the comma button in the formatting tool bar, to have excel display this as a fully written out number. Note also that calculation in XL is limited to 15 digits of precision. Dave -- Brevity is the soul of wit. "SueK" wrote: Why do i get 6.7e+09 in a cell when i tried to type in 6680344953? I know that I can resolve this problem by changing the cell to text format but why does it happen sometimes and not other times? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting a formula when typing long numbers
Cells formatted as "Number" will display either numbers, if the cell is wide
enough, or #'s if the cell is too narrow, where all that is necessary to display the numbers is to make the cell wider. Cells formatted as "General" however, will give you those scientific notations, if your number is 12 digits or larger, no matter how wide the column was at the start. Simply reformat the General cells to Number to eliminate the scientific notation. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "SueK" wrote in message ... Why do i get 6.7e+09 in a cell when i tried to type in 6680344953? I know that I can resolve this problem by changing the cell to text format but why does it happen sometimes and not other times? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting a formula when typing long numbers
Thank you for clearing this up for me. I really appreciate the help.
"RagDyeR" wrote: Cells formatted as "Number" will display either numbers, if the cell is wide enough, or #'s if the cell is too narrow, where all that is necessary to display the numbers is to make the cell wider. Cells formatted as "General" however, will give you those scientific notations, if your number is 12 digits or larger, no matter how wide the column was at the start. Simply reformat the General cells to Number to eliminate the scientific notation. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "SueK" wrote in message ... Why do i get 6.7e+09 in a cell when i tried to type in 6680344953? I know that I can resolve this problem by changing the cell to text format but why does it happen sometimes and not other times? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting a formula when typing long numbers
Thank you for your help in clearing this up for me.
"Dave F" wrote: 6.7e+09 is 6.7*10^9, that is, scientific notation. Try widening the column or else clicking the comma button in the formatting tool bar, to have excel display this as a fully written out number. Note also that calculation in XL is limited to 15 digits of precision. Dave -- Brevity is the soul of wit. "SueK" wrote: Why do i get 6.7e+09 in a cell when i tried to type in 6680344953? I know that I can resolve this problem by changing the cell to text format but why does it happen sometimes and not other times? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting a formula when typing long numbers
Regardless of how I reformat my cells, the result is the same. The number
may be converted to the original version, however, the last two digits are always zero. 00600019600000000018 first appears as 6.0002E+17 and after reformatting it converts to 600019600000000000. Any suggestions would be greatly appreciated! "Dave F" wrote: 6.7e+09 is 6.7*10^9, that is, scientific notation. Try widening the column or else clicking the comma button in the formatting tool bar, to have excel display this as a fully written out number. Note also that calculation in XL is limited to 15 digits of precision. Dave -- Brevity is the soul of wit. "SueK" wrote: Why do i get 6.7e+09 in a cell when i tried to type in 6680344953? I know that I can resolve this problem by changing the cell to text format but why does it happen sometimes and not other times? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting a formula when typing long numbers
You can't have more than 15 significant digits in Excel, that is all.
Anything past that is zeros. DebS wrote: Regardless of how I reformat my cells, the result is the same. The number may be converted to the original version, however, the last two digits are always zero. 00600019600000000018 first appears as 6.0002E+17 and after reformatting it converts to 600019600000000000. Any suggestions would be greatly appreciated! "Dave F" wrote: 6.7e+09 is 6.7*10^9, that is, scientific notation. Try widening the column or else clicking the comma button in the formatting tool bar, to have excel display this as a fully written out number. Note also that calculation in XL is limited to 15 digits of precision. Dave -- Brevity is the soul of wit. "SueK" wrote: Why do i get 6.7e+09 in a cell when i tried to type in 6680344953? I know that I can resolve this problem by changing the cell to text format but why does it happen sometimes and not other times? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting a formula when typing long numbers
Unless you need that level of precision, which is extremely unlikely, use
text rather than numbers. Simply precede your entry with an apostrophe (or pre-format the cells to Text). Regards, Fred. "DebS" wrote in message ... Regardless of how I reformat my cells, the result is the same. The number may be converted to the original version, however, the last two digits are always zero. 00600019600000000018 first appears as 6.0002E+17 and after reformatting it converts to 600019600000000000. Any suggestions would be greatly appreciated! "Dave F" wrote: 6.7e+09 is 6.7*10^9, that is, scientific notation. Try widening the column or else clicking the comma button in the formatting tool bar, to have excel display this as a fully written out number. Note also that calculation in XL is limited to 15 digits of precision. Dave -- Brevity is the soul of wit. "SueK" wrote: Why do i get 6.7e+09 in a cell when i tried to type in 6680344953? I know that I can resolve this problem by changing the cell to text format but why does it happen sometimes and not other times? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help setting the worksheet header/Footer margins based on string height? | Excel Discussion (Misc queries) | |||
More than 3 conditional formats? | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
more than 3 conditions in conditional formatting - possible? | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |