problem with pasting & #value

  • Thread starter Thread starter geofffra
  • Start date Start date
G

geofffra

Hi,

I hope some one can help.
I have created a spreadsheet to extract data and sort it int
individual worksheets for the work, units and time individuals hav
done daily. This data is then copied to the bosses non modifiabl
spreadsheet.
My problem is:
I am trying to copy& paste data from my SS with formulas to to th
other. The cells pasted into only have formatting of numbers and time
The pasted blank cells with "" criteria return a #value in th
calculations column of the bosses. Can anyone help with a means o
removing what I assume are non priting characters being pasted from m
sheet. This is all currently done with macros, but do I need to take
different track.

Thanks

Geoff :
 
Thanks Bob,

Looks like some reading ahead. So far a quick glance at the site does
not give the answer, but I will have a much closer look.

As everything works well with zero values in the cells(boss hates the
zeros), my thoughts are that I some how need to search through all the
cells and delete ALL zero values before cut @ paste
 
Why not just change the boss' spreadsheet to suppress zeros,
Tools>Options>View and uncheck zero values.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Thanks Bob,

I was unaware of that feature.
Now to see if boss is happy with that solution as i think they do more
with it at head office and payroll.


Geoff.:eek:
 
Or if you want to be more selective is what cells you want to blank out the zeros
(zeros are useful, they mean someone entered something, unless it is a formula)
you can use cell formatting with the third operand empty

Format cell in normal way then modify the 3 third operand to empty

General becomes General;-General;;@
or General;-General;;

_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
becomes
_(* #,##0.00_);_(* (#,##0.00);;_(@_)
--
 
Back
Top