i have spreadsheet using various vlookups from other sheets. Need to special
paste values of vlookups in new sheet. If vlookup picks up a blank cell then
the pasted value on new sheet is showing ' instead of a blank cell. I need
to have a blank cell and not a label symbol. How do I and on what sheet do I
change format and which format should I be using? sheet 1 is vlookup
formulas, sheet 2 and 3 is information sheet 1 is looking up. I need the new
sheet to save as txt file for importing to other program.
--
suesea