date extraction howto?

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

solo_razor

hello,

I want to extract numbers from a date generated by excel
example:
cell a 119 contains as value 10/30/2003
now i want to use a formula that extracts the 10 and place that into
another cell.
Another formula must extract 30 and place this into another cell
and the last formula schould extract the 2003 and place this into
another cell.

so a119 = 10/30/2003
e.g.
a120 = 10
a121 = 30
a122 = 2003

Regards,

Niek
 
Back
Top