View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales K Dales is offline
external usenet poster
 
Posts: 131
Default disable formatting

Answer would depend on the exact method you are using to
import it (Text file? External data query via ODBC? VBA
routine?) However, it might just be simpler to set up a
routine to format that column as text after the import -
it will force Excel to read treat your housenumbers as
text.

-----Original Message-----
Hi,

I wrote an excel/html output from a database, but when it

gets imported, the
housenumbers that are formatted like "9/13" or "13-17"

get formatted as a
date.
Is there a way to turn this of, or to make sure this

doesn't happen?

Regards
Tim De Vogel
S-Data NV

.