How many decimal places can a cell display?
Here is one that shows 15 digits
? application.pi()
3.14159265358979
or in the worksheet
=pi()
and format the cell to show 14 decimals.
--
Regards,
Tom Ogilvy
"Spaz" wrote in message
. ..
Thanks. I'm getting 14 now with this little procedure.
"Pete_UK" wrote in message
oups.com...
You can only get 15 digit precision in Excel.
Pete
|