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


"madhead4000" wrote:


Hi there, Im currently doing my AS coursework an am needing to do my
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 at
the end? For example 3.1415926 would be displayed as 3.141592600000. Any
help would be much appriciated. Thanks, Nick ;)


--
madhead4000
------------------------------------------------------------------------
madhead4000's Profile: http://www.excelforum.com/member.php...o&userid=33125
View this thread: http://www.excelforum.com/showthread...hreadid=529361