Thanks to all for the help and support. As of now it is confirmed
that this cannot be done Can this be done by a macro.

My requirement is like this:

I have a sheet called "Master" which contains column headers and
rows ie designed as records and fields. THe first column contain the
name of the employees and other column related data for the
employees.

The next sheet contains a sheet named "Computation". This is a
format in which I need the output. The cell  A5 of Computation sheet
contains a drop down list(via DataValidation, List ) which contains
the name of the employees.
Other fields are made with Vlookup formula so the data in the
relevant cells  are those of the presons named in cell A5. So when I
change the name at cell A5, the data are also chages. Now in the
cells for some person may have numbers and for some persons the data
may be 0 (Zero) and this zero data I wnat to present as NIL.