| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
only show decimals
I have a need to only show the figure to the right of a decimal point not the
whole number. Reason is to calculate the best bar length to use i.e. the decimal bit is the size of the offcut and I need to find the optimum size. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only show decimals
You could use another cell:
=mod(a1,1) or =a1-int(a1) Steve Holbrook wrote: I have a need to only show the figure to the right of a decimal point not the whole number. Reason is to calculate the best bar length to use i.e. the decimal bit is the size of the offcut and I need to find the optimum size. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only show decimals
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show only the whole number w/o eliminating four decimals? | Excel Worksheet Functions | |||
| no decimals | Excel Discussion (Misc queries) | |||
| decimals only. | Excel Discussion (Misc queries) | |||
| How to only show decimals if there are any | Excel Discussion (Misc queries) | |||
| Rounding Decimals | Excel Worksheet Functions | |||
Linear Mode
