date extraction howto?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top