Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
maths +"standard form"
How can I get excel to return a calculation in standard form?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
maths +"standard form"
Perhaps you can explain what you mean by "standard form"?
-- Kind regards, Niek Otten Microsoft MVP - Excel "deetee" wrote in message ... | How can I get excel to return a calculation in standard form? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
maths +"standard form"
What is your conception of "standard form"?
Gord Dibben MS Excel MVP On Sun, 4 Nov 2007 14:14:01 -0800, deetee wrote: How can I get excel to return a calculation in standard form? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
maths +"standard form"
I will work on the assumption that by "standard form" you mean a number in
the from 4567 (as I recall standard form is 4567; expanded form is 4×10^3 + 5×10^2 + 6×10 + 7) So I will further conclude that you are getting scientific notation ( 4.567 ×10^3) when you do not want it. Solution: select the cell(s), use Format | Format Cells| specify Numbers and set the number decimals as needed (zero for integers). Caveat: Excel uses the IEEE method of storing numbers so you are limited to 15 digits of precision. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "deetee" wrote in message ... How can I get excel to return a calculation in standard form? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
maths +"standard form"
So I will further conclude that you are getting scientific notation
(4.567×10^3) when you do not want it. Solution: select the cell(s), use Format | Format Cells| specify Numbers and set the number decimals as needed (zero for integers). The answer to this one could also possibly be to just widen the column. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Standard font in a "New Microsoft Excel Worksheet.xls" wont change | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |