| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How many decimal places can a cell display? | Excel Worksheet Functions | |||
| Highest & lowest place value / decimal places of cell value | Excel Worksheet Functions | |||
| Setting the number of decimal places for a text box. | Excel Discussion (Misc queries) | |||
| Finding Values With more than 2 decimal Places | Excel Discussion (Misc queries) | |||
| Aligning data with varying decimal places | Excel Discussion (Misc queries) | |||
Threaded Mode
