Okay i also tried this and it does work period. Let me tell you exactly what
i am doing, we work with a program called MAS 90 and we go in and export our
orders into excel we get a excel sheet and copy and paste it onto a template
sheet thats where the raw form and order form all are and in the order form
it is set up with a name address and phone number and then if there isnt
anything under the first line in the address it puts a 0 there and in the
formula bar on the order form it say the =RAW!F1 like it is bringing
information over from the raw form into the order form. I dont want this
zero there i want it to be gone forever every time we update it i dont there
to be any zero

"Max" wrote:

.. but if there are any calculations tied to this cell, it could "gack".
Possibly so, Barb. Then again it's one of the usual options availed for neat
appearances when it comes to simple link formulae. One other way I'd consider
is to simply switch off zeros display in the sheet, via Tools Options
View tab.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---