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