Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActivX in Excel
How can I get spinner buttons to show decimal places in Excel?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActivX in Excel
Spinner buttons don't show anything unless you link them to a cell. When
you do they show whole numbers. So link the spinner to the cell below the spinner. Then in the place where you want the number displayed, use a formula like =A1/10 Where A1 contains the whole number and is underneath the spinner so it can't be seen. -- Regards, Tom Ogilvy "Kyle" wrote in message ... How can I get spinner buttons to show decimal places in Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|