Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spinboxes In MS Excel 2003
Can you use non whole numbers in Spin Boxes in excel spreadsheets. Can you
input values less than one( .5, .05, .002) etc. into the incremental change field in the Spin Box, Format Control tab when you right click on the spin box? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spinboxes In MS Excel 2003
Chris,
Not in the control dialogue itself, but by setting up a formula that were to say divide the contents of the cell under the control by two you could create a gearbox - ie a change increment on one divided by two would give you a half. Hope this is clear Corin |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spinboxes In MS Excel 2003
Corin,
Thanks for all of your help. I can now do real time ROI calcs with the click of my mouse. "Corin" wrote: Chris, Not in the control dialogue itself, but by setting up a formula that were to say divide the contents of the cell under the control by two you could create a gearbox - ie a change increment on one divided by two would give you a half. Hope this is clear Corin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |