Help with formating cells (decimal places)

M

madhead4000

Hi there, Im currently doing my AS coursework an am needing to do m
calculations to a degree of accuracy (12 d.p.). My question is:
How do i make it so that if the number doesnt end in a bunch of 0's a
the end? For example 3.1415926 would be displayed as 3.141592600000. An
help would be much appriciated. Thanks, Nick ;
 
D

Duke Carey

So, what you want is for the value to display UP TO 12 d.p.s, if required?

You can try using a custom format of

0.0###########

Which will always display 1 decimal point & up to 12, if the value goes that
far out
 
Top