Home |
Search |
Today's Posts |
#1
|
|||
|
|||
place empty cell with zero
I am trying to place zero in place of empty cells in my worksheet, i used
formula =IF(A2="",0,A2) But this formula is also placing zero for a cell having value(number), i donot want the cells with values to be filled with zero, i want only empty cells in my sheet to be filled with zero. can anyone help me plz. |
#2
|
|||
|
|||
Try
=IF(ISBLANK(A2),0,A2) or IF(LEN (A2)=0,0,A2) -- HTH RP (remove nothere from the email address if mailing direct) "prince" wrote in message ... I am trying to place zero in place of empty cells in my worksheet, i used formula =IF(A2="",0,A2) But this formula is also placing zero for a cell having value(number), i donot want the cells with values to be filled with zero, i want only empty cells in my sheet to be filled with zero. can anyone help me plz. |
#3
|
|||
|
|||
Hi
choose edit / goto and click on the special button choose blanks and click ok this will select all the empty cells then (without clicking anywhere) type a 0 and press control & enter this will put a 0 in all the selected cells - note, it is a good idea to try something like this on a copy of your workbook first. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "prince" wrote in message ... I am trying to place zero in place of empty cells in my worksheet, i used formula =IF(A2="",0,A2) But this formula is also placing zero for a cell having value(number), i donot want the cells with values to be filled with zero, i want only empty cells in my sheet to be filled with zero. can anyone help me plz. |
#4
|
|||
|
|||
Make sure you do this on a copy of your workbook, in case there are
unintended consequences 1) Select the range of cells you want to have affected this way 2) press F5, click on 'Special' and select Blanks, then click on OK 3) Type a 0 (zero) and press Ctrl-Enter "prince" wrote: I am trying to place zero in place of empty cells in my worksheet, i used formula =IF(A2="",0,A2) But this formula is also placing zero for a cell having value(number), i donot want the cells with values to be filled with zero, i want only empty cells in my sheet to be filled with zero. can anyone help me plz. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
cell that accepts a whole number or five place deciaml | Excel Worksheet Functions |