Help in converting monthly data do daily data

Hi everyone,

I have here a little problem:

I have one Excel spreadsheet where I have this type of data:

Please Login or Register  to view this content.

And this until 01-12-1960 09:00. So, what I want is a VBA code that can convert this monthly data to daily data, where for each daily data I would have the monthly data divided by the number of days that month has. I do not know if I am explaining myself in the right form. But an example of the result would be..

Please Login or Register  to view this content.

And so on until 01-12-1960 09:00.

Can anyone give me an help? If I was not clear please say so, so that I can explain in a different way

Thank you

307,1
Is the comma suppose to be a decimal point? If yes, then try this...

Please Login or Register  to view this content.

Dear AlphaFrog,

This works like a charm! Thank you so much for the help!

Btw, yes, I usually use comma as a decimal point! Thanks

i have a similar problem. please whta excel formular can i use to convert monthly data to daily data