Currency format

J

Jeff

Hi Everybody

I have a form with a textbox that holds the total cost of a course:
PriceTotal
there is also another textbox that holds the number of installments: Inst
Now, the PriceTotal is formated as currency and shows great.
I have another textbox, MonthPay, that has the result of PriceTotal divided
by Inst.
This box is also formatted as currency.
The problem is that it is putting a zero on the front:
PriceTotal = $300
Inst = 6
MonthPay = $050
I don't know why it's happening as there is no specification of minimum
characters etc.

What's gone wrong?

Any advice would be greatly appreciated. Have a nice day,

Jeff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting Problem 3
TextBox on a userform - format to currency & percent 2
numbers and conditional formatting. 3
Currency Format 5
Currency designations 2
Currency format lost when merging into Word 1
Currency formatting problem - Excel 2003 1
Currency with Infopath & Access 3

Top