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!