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/

converting a number to a date
 

Lookup the function FormatDateTime in help.
-----Original Message-----

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/

.

converting a number to a date
 

Hi Niek,

Excel is probably treating the cell values as text, not numeric entries. To
force Excel to reevaluate the values, do the following:

1) Enter 0 in an empty cell.
2) Copy that cell.
3) Select the range of cells giving you problems.
4) Paste Special values & Operations/Add

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


AA wrote:
Lookup the function FormatDateTime in help.
-----Original Message-----

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/

.