converting a number to a date

  • Thread starter Thread starter solo_razor
  • Start date Start date
S

solo_razor

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
 
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]
 
Back
Top