| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where to get 32nds as a number format in Excell or how to keep f
I'm attempting to use functions on integers and fractions; fractions are
32nds; I want them to stay 32nds and NOT round up or down. All I've located so far are 16ths. This will not work, or would require additional steps to convert. Isn't there an easier method? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where to get 32nds as a number format in Excell or how to keep f
look here
http://www.mvps.org/dmcritchie/excel/fractex1.htm Mike "wiljo" wrote: I'm attempting to use functions on integers and fractions; fractions are 32nds; I want them to stay 32nds and NOT round up or down. All I've located so far are 16ths. This will not work, or would require additional steps to convert. Isn't there an easier method? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where to get 32nds as a number format in Excell or how to keep f
FormatCellsNumberCustom ?/32
Gord Dibben MS Excel MVP On Sat, 1 Mar 2008 12:59:01 -0800, wiljo wrote: I'm attempting to use functions on integers and fractions; fractions are 32nds; I want them to stay 32nds and NOT round up or down. All I've located so far are 16ths. This will not work, or would require additional steps to convert. Isn't there an easier method? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excell number formatting | Excel Worksheet Functions | |||
| Number Entry in Excell | Excel Discussion (Misc queries) | |||
| editing documents with excell that are not excell format | Excel Discussion (Misc queries) | |||
| Format numbres to 32nds | Excel Discussion (Misc queries) | |||
| How do I get excell to indicate when a number is out of a set ran. | Excel Worksheet Functions | |||
Linear Mode
