| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Formatting Decimal Point
How do you set the workbook to expand the cells to the last digit after the
decimal point but not display any trailing zero's? Example how would you display A1=3.15476 & A2=4.2 instead of A1=3.15476 & A2=4.20000 without setting the format individually for every cell, and without any rounding involved? Thanks, ben |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal point | Excel Discussion (Misc queries) | |||
| how to stop excel from auto formatting whole number to decimal % | New Users to Excel | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| Why am I getting .+ when I hit the decimal point? | Excel Discussion (Misc queries) | |||
Threaded Mode
