inserting numbers into db

I have to insert numbers into a table using sql
statements. However, some of the numbers have digits,
and sql interprets these numbers as different fields.
I have tried using (,[,",',etc, but nothing works. I
also used a trick to format the numbers and changing
the comma into a point. This works, except when the
numbers are greater then 10000, in which case I get
10.000.000 and an error.

Tim Devoldere 

A: Function Format Have you looked at the Vb funtion Format. With this function you can format anything to a certain mask. I use it to translate all dates (dd-mm-yy) into db-dates (yyyy-mm-dd). It can also be used to format numbers.. Return