Hard to tell what you are doing, but if I format the cell as MM and put in
an actual date, then in the immediate window, these queries show the
situation:
? activecell.Text
02
? activecell.NumberFormat
mm
? activecell.Value2
38760
? activecell.Value
2/12/2006
so the actual number stored in the cell is 38760 which is the date serial
for the date I entered 2/12/2006.
If you want to multiply by the month number then (assume the cell is B9) use
=month(b9)*283.8
--
Regards,
Tom Ogilvy
"denileigh" wrote
in message ...
Simple Question I hope.....not for me obviously.
I have a field that puts in the current month formatted as 02. I need
to take that number and multiply it by a payment to get a current
balance due for the year.
For example 02 (current month) x 283.8 (payment) = 567.60
Right now the date format in the 02 is returning a goofy number.
Any ideas?
THANKS!
--
denileigh
------------------------------------------------------------------------
denileigh's Profile:
http://www.excelforum.com/member.php...o&userid=30211
View this thread: http://www.excelforum.com/showthread...hreadid=516891