If you're trying to fill blanks with zeroes, try this. Select the range. Hit
Edit--go to--Blanks. Type a zero and hit Ctrl+Enter.
************
Anne Troy
www.OfficeArticles.com

"carl" wrote in message
...
I have my data in a table like this:

Data Table BOX017 BOX060 BOX161
A 109
B 38275 4
C
D

I am trying to find a formula to use in the body of this new table that
will
give the results below:

New Table BOX017 BOX060 BOX161 BOX226
A 0 109 0 0
B 38275 0 4 0
C 0 0 0 0
D 0 0 0 0

Thank you in advance.