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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Changing low number of "-"
Hi Janet
You could try FormatCellsNumberCustom [<0.05]"-";General Play about with different combinations to get what you want for the normal format when not less than 0.05 -- Regards Roger Govier "Janet" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Changing low number of "-"
Would a Custom format of
[<0.05]"-";General in the potentially affected cells do what you want? This will not change what held in the cell, it will still have the same value. If it is the result of a calculation - say A1*B1 - then use: =IF(A1*B1<0.05,0,A1*B1) and format as accounting to get a true zero in the cell. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Janet" wrote in message ... 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 |
Reply |
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 |