| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete cells with 0 as the tenth digit
How do I delete cells with zero as the tenth digit? I've tried using the
formula =IF(MID(AE2575,10,1)="0",1,AE2575) but it doesn't return the actual cell value if the tenth digit isn't zero. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cells with 0 as the tenth digit | Excel Worksheet Functions | |||
| ROUND() to tens or hundreds (not tenth/hundredths)! | Excel Worksheet Functions | |||
| How to delete fist 6 digit of all contents in a column? | Excel Discussion (Misc queries) | |||
| In excel, how can i delete 1 digit and the decimal point? | Excel Worksheet Functions | |||
| How do I set up a formula in excel that is the tenth root of 7 ve. | Excel Worksheet Functions | |||
Threaded Mode
