Changing number field with date data to show in ddmmyyyy format

[gatorfe]

There is date field that a user added to a crosstab report as a measure and changed the data format from date to number.  The format the data looks like is 20101201(yyyymmdd).  The user wants it to show as 01122010(ddmmyyyy) instead.  Any suggestions on how I can do this?  Thanks in advance for any insight! 

[mahgar]

For whoever may face the same problem.

In Data Format,
Changed it to Long, Day, Month Year, show years, month = 2digits, days = 2 digits.

Thanks