"Miguel Zapico" wrote in message
...
You can try with TEXT, like this:
=TEXT(A1,"yyyymmdd")

There I told you there may be better ways! <g
--

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk