| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Number Display
"Gord Dibben" <gorddibbATshawDOTca@ wrote in message ... Lee Have you looked at FormatCellsNumberFractions? Various options there including halves which is the accuracy you specify. Gord Dibben Excel MVP On Tue, 06 Dec 2005 00:35:21 GMT, "Lee Harris" wrote: How can I get values to display in fractional form (only need accuracy to 0.5) while still being able to calculate with the values (or do I need a separate column with a funky text format?) doh! :-) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom number format button | Excel Discussion (Misc queries) | |||
| custom cell number | Excel Worksheet Functions | |||
| Why does Custom Format not control Cell Display? | Excel Discussion (Misc queries) | |||
| Display a greater number of recently used spreadsheets on File ta. | Excel Discussion (Misc queries) | |||
| In Excel how can a number automatically display in text form | Excel Worksheet Functions | |||
Threaded Mode
