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