Excel help

I have a cell (A49) which computes NOW() customised to give the month (say for May it would show "5"). If I have a formula in another cell as "=((A49/12)*172.5)/3600" but the value is not 5 but 40325.5. How can I get the displayed month value across?

  VoG II 11:50 27 May 10

Try

=((MONTH(A49)/12)*172.5)/3600

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now