Help with formating cells (decimal places)

[madhead4000]

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

[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


"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
>
>