Custom plant list worksheet not bringing in data correctly

[Doug L]

When I added a custom field to my plant list worksheet, why does the data from the VW database not show up in the plant worksheet properly? Growth Height (='Plant Record'.'Height') should be 24 - 36 In, but the result is only 24. Growth Spread (='Plant Record'.'Spread') should be 36 - 48 In, but the result is just 36. The plant list worksheet strips out everything after the 1st number. The same thing happens for plants that are measured in feet, 3 - 4 FT becomes just 3 and can be confusing without Feet or Inches. I tried changing the cell's formating to Text or General but that had no effect.