Happy Pi Day Everyone!

[Scott Huish]

=text(substitute(round(left(pi(),7),4),".",""),"00\/00\/00")

 

[Joe4]

 

[Rick Rothstein]

=text(substitute(round(left(pi(),7),4),".",""),"00\/00\/00")

Why not go all the way...

=TEXT(1000000000*PI(),"0\/00\/00 0\:00\:00.00000")

I know the fractional seconds are a bit much, but still.

 

[mole999]

Lost on me

[TABLE="width: 72"]
<colgroup><col width="72"></colgroup><tbody>[TR]
[TD="width: 72"]3/14/15 9:26:53.59

I have no idea how that relates to 3.142857
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

The first bunch of digits of PI is: 3.14159265359.
It is not 3.142857 (that is the lazy man's estimate of 22/7).

 

[Scott Huish]

This seems to get you the correct date of today. The rounding was to force it to 16. This is just a displayed rounding.

=TEXT(10000*PI(),"0\/00\/00")

 

[Rick Rothstein]

...that is the lazy man's estimate of 22/7

I have always found the following to be a better estimate of PI (correct to 6 decimal places)...

355/113

and the number is quite easy to memorize... the first three odd digits (1, 3 and 5) doubled up (113355) split in the middle (113 and 355) with the larger value divided by the smaller value.

 

[mole999]

The first bunch of digits of PI is: 3.14159265359.
It is not 3.142857 (that is the lazy man's estimate of 22/7).

So my education was flawed, typical