View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Convert int ccyymmdd to date(time)

Well, I'm sorry, Pat, but I don't understand what you are trying to
do, or what the problem is.

Pete

On Jul 24, 1:06*am, " wrote:


Hi Pete,

Now the formula is _not_ what I want to do. *It's an example of 'the
other direction'.

I want to have a ccyymmdd int sitting in a cell and then convert it to
the equivalent datetime in a different cell.

pat