View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Benny Benny is offline
external usenet poster
 
Posts: 16
Default I don't need the actual value but what is shown

Hello. I have a cell F10 that needs that needs to be divided by the current
month. Example. D10 has a value of 100 and it needs to be divided by 10
because the current month is October.

I tried to use in cell A10 Today() then format that cell to m and it shows
the number 10.

So that works fine but the result for F10 is 0 because the true value of
that cell A10 is 10/28/2009.

Thanks