| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore leading zeros in a formula cell
Ok...heres an example of my problem
cell A1 contains the Letters "right" Cell B1 contains a formula: =if(A1="right",.08+.04,.03+.02) Since the if statement is true Cell B1 returns this value: 0.012 How do I get rid of the zero before the decimal point? Any help would be appreciated |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ignore leading zeros in a formula cell
You could apply a custom format:
Format|Cells|number tab|custom category ..000 or ..00 (but isn't the sum really .12?) TravEyE wrote: Ok...heres an example of my problem cell A1 contains the Letters "right" Cell B1 contains a formula: =if(A1="right",.08+.04,.03+.02) Since the if statement is true Cell B1 returns this value: 0.012 How do I get rid of the zero before the decimal point? Any help would be appreciated -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ignore leading zeros in a formula cell
Format Cells... Number Custom .00
-- Gary''s Student - gsnu200766 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LEADING ZEROS IN FORMULA RESULT | Excel Worksheet Functions | |||
| leading zeros are not showing in the formula bar but do show in ce | Excel Discussion (Misc queries) | |||
| Format a cell to keep leading zeros. | New Users to Excel | |||
| How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Linear Mode
