Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TextBox Formatting
How do I format a UserForm TextBox to round decimal numbers to the nearest whole number. ie 1.0, 1.1, 1.2, 1.3, 1.4 should all round down to 1. 1.5, 1.6, 1.7, 1.8, 1.9 should all round up to 2. I can get it to display the Interger but this always rounds down. -- grahammal ------------------------------------------------------------------------ grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336 View this thread: http://www.excelforum.com/showthread...hreadid=532225 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textbox moves position when Printing? | Excel Discussion (Misc queries) | |||
Legnth of text in textbox control | Excel Discussion (Misc queries) | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Help needed with textbox formatting in Excel 2000 | Excel Discussion (Misc queries) |