Hi, I'm trying to work out a formula in excel which requires me to use Pi to over 30 decimal places. Excel will only let me have 30 decimal places of Pi whether I copy and paste it as a number or use its Pi function and even then seems to round up. Is there any way I can get more than 30 decimal places for this calculation? If not in excel then can anyone suggest another programme that may be capable of this?
You can post here or contact me at
x_paddypaws_x@hotmail.com
Thanks in advance
Mini xxx
EDIT : I worked out how to get more decimal places but I also worked out that excel is rounding up after 14 decimal places which defeats the object of allowing me to see 30 decimal places somewhat... Is there any way I can prevent this auto rounding?
Bookmarks