| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Changing low number of "-"
Folks
One of my users would like to know if its possible to automatically have numbers lower than 0.049 be changed so the cell displays a dash " - " instead. I've tried using autocorrect, but that will only change a specific number and not every number below 0.049. Does anyone have any ideas? Thanks. -- Janet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HLOOKUP copied across rows with "row index number" changing | Excel Worksheet Functions | |||
| How to keep "text" number from changing to date.... | New Users to Excel | |||
| " / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
| " / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Threaded Mode
