I am generating an Excel spreadsheet from code in Access and I have noticed that during the export a string containing a decimal point will be replaced with and under score for eg. "3.5 metres" in Access becomes "3_5 metres" in Excel.

I am using the Excel object library to create the excel application and DAO to create the sql for the export.

Any ideas?

Many thanks,