View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
solo_razor[_26_] solo_razor[_26_] is offline
external usenet poster
 
Posts: 1
Default converting a number to a date


hello,

I have a number that is actually a date, now i want to convert this
number back to a date, i have tried to do that with cell formats en
with the macro recorder, but the value in the cell remains the number
until you click on it several times. It must be converted at once
because several functions are depending on it.

Regards,
Niek


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/