V-Lookup Data Formats Imported from Crystal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I use data imported from Crystal in a V-Lookup, it appears to be in
number or general format, but the lookup function fails. I can make it work
cell by cell if I copy from one list to another, but that is slow! Any way
to get imported data into the correct format automatically?
 
Hi
try after importing:
- select an empty cell and copy it
- select your importted data
- goto 'Edit - Paste Special' and choose 'Add'
 
Back
Top