View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
madhead4000
 
Posts: n/a
Default Help with formating cells (decimal places)


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