how to change order numbering from alpha numberic

How do I change the order numbering from alphanumberic to just numeric?

I see under config

Order

Order Number Format {automatic_code}

I believe that I'll need to clear out the orders from virtuemart and re import them, can you give clear directions on how to remove past orders and re import them from virtuemart database?

Joomla

Thank you for your reply, just to clarify I need to change order number format from {automatic_code} to {id} ??

And then do the same for the Invoice number format??

I did the query worked great, had a error the first go, but it took the second time.

UPDATE #__hikashop_order SET order_number=order_id WHERE 1;

I didn't notice the second _ removed it and all is swell.

Thanks things are working a little better now.