Why would you divide a money by a date? That will be dividing by 37344 for
example which seems a bit arbitrary.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DTTODGG" wrote in message
...
Hello-
I have an excel file sent to me everyday.
Col G is formatted as "DATE" not general (2/8/2006)
Col H is a money field.

Col I - I want to find out how much money/day (formatted as "currency".

Take "today" - Col G and divide by Col H put in Col I.

The problem is Col G is not a "general" field. I suppose I could everyday
change Col G to "General", but then people can't figure out what date
37344
is.

Is there a clean way to do this?
Thank you so much - I hate working with dates in excel!