one way;
copy the date and then paste special values
HTH

"Roger B." wrote:

I have a date in a cell which is in Date format and I would like to convert
this to a whole number format (ie no decimals in the result) using a macro.



Any suggestions would be greatly appreciated.



Roger