View Single Post
  #5   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Tom Ogilvy
 
Posts: n/a
Default 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