Re: How does Base interpret Calc data types?

Hello Filip Lannoye,
Open the spreadheet, select the "STREET NUMBER" column and call 
Format>Cells...Tab:"Number Format" and declare it explicitly as text 
(bottom of left listbox). This will affect new values only while the 
existing ones remain numbers.

Call Edit>Find&Replace
Button: "More Options"
[x] "Selection only"
[x] "Use regular expressions"
Search: .+
Replace: '&
Replace all.

This searches for any char in a cell (.), at least one of any char (+), 
and replaces what has been found with itself (&) and a leading '. The ' 
is not part of the cell's value. It just marks a text-value.