| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add the $.00 pennies if no value is present after the whole number?
Hey all!
The idea is the following... A person enters a value in to a textbox. Based on the valued entered it may or may not have change... this is simply for uniformity in the database. I'd like the following to happen... End User types "$9.99" into textbox - nothing happens as it does have a value after the period. End User Types "$9" into textbox on exit the text box adds the ".00" so it comes out to be "$9.00" Any help is greatly appreciated!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding up number of people present at certain times | Excel Worksheet Functions | |||
| Why is my sum total a couple pennies off from what it should be? | Excel Discussion (Misc queries) | |||
| How can I add present month, as number, to an header in excel? | Excel Discussion (Misc queries) | |||
| How to count the number of cells highlighted using Conditional Formatting feature present in Format Menu of Excel??? | Excel Programming | |||
| How can I count number of sheets present in a workbook? | Excel Discussion (Misc queries) | |||
Threaded Mode
