Hi

THis is a bit cumbersome, but it works:
=VALUE(TEXT(A1,"dd"))

Andy.

"DB Explorer" wrote in message
oups.com...
Thanks Andy,

This works, and displays 04, but I am unable to use this for
mathematical functions, it needs to be a number format