My locally open worksheet has a query that is supposed to sync it with
a multicolumn named range of another worksheet on a server.
Everything syncs fine except one column containing zeros or short text
(2-9 characters).
Zeros get synced instead of text i get blank cell. See a sample below:

Source:
Detail Pref Time COD
Pressure Pad & Pump, 2 PM, 12-4 $0.00
Patient Lift , Trapeze , 1 PM12-4 $0.00
RT, 10195 0 $0.00
RT, 10195 0 $0.00

Destination:
Detail Prefs: 169904 Time COD
Pressure Pad & Pump, 2 $0.00
Patient Lift , Trapeze , 1 $0.00
RT, 10195 0 $0.00
RT, 10195 0 $0.00

In destination rows information: PM, 12-4 and PM12-4 is missing.

Anyone can figure it out?

Georgee