| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Empty cell - zero
Thank you very much. It works!!!
Regards, User Użytkownik "Biff" napisał w wiadomości ... Hi! Hit function key F5 Click the Special button Select blanks OK This will select all empty cells in the USED RANGE. Enter a 0 in the formula bar then press CTRL ENTER. Biff "User" wrote in message ... Hi, I've got an Excel file where some cells include zeros and some are empty instead of including zero. I need to have zeros in all empty cells. How to do it for all cells in a sheet? I tried to use a "special copy" - without success. I also tried to change them using Edit from the menu but the empty cells are not found. I use Excel97. There are no formulas, just numbers in the sheet. Please help me. It's urgent. :-) Regards, User |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
| Dropping the cell in the empty cell by formula | Excel Discussion (Misc queries) | |||
| How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
