Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel validation to 1 decimal place
I want to restricted cell input to 1 delimal place ie 77.9.
if user tries to input 77.09 or 77.48 or any figure to two decimal place they are prevent and must put in ie 77 or 77.4. Any ideas |
#2
|
|||
|
|||
Tracy wrote:
I want to restricted cell input to 1 delimal place ie 77.9. if user tries to input 77.09 or 77.48 or any figure to two decimal place they are prevent and must put in ie 77 or 77.4. Any ideas You could right click and select format number and then tell it only 1 decimal. It won't prevent them from putting one in but it will round it to 1 decimal. gls858 |
#3
|
|||
|
|||
You could use a custom data validation:
Select the cell Choose DataValidation From the Allow dropdown, choose Custom In the Formula box, type a formula that refers to the selected cell, e.g.: =D3=ROUND(D3,1) (optional) Add an Input Message and/or an Error Alert Click OK Tracy wrote: I want to restricted cell input to 1 delimal place ie 77.9. if user tries to input 77.09 or 77.48 or any figure to two decimal place they are prevent and must put in ie 77 or 77.4. Any ideas -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
That will only change the display, the underlaying value is the same
-- Regards, Peo Sjoblom "gls858" wrote in message ... Tracy wrote: I want to restricted cell input to 1 delimal place ie 77.9. if user tries to input 77.09 or 77.48 or any figure to two decimal place they are prevent and must put in ie 77 or 77.4. Any ideas You could right click and select format number and then tell it only 1 decimal. It won't prevent them from putting one in but it will round it to 1 decimal. gls858 |
#5
|
|||
|
|||
Thank you Debra.
I see where I went wrong (two = signs)! Makes sence now. "Debra Dalgleish" wrote: You could use a custom data validation: Select the cell Choose DataValidation From the Allow dropdown, choose Custom In the Formula box, type a formula that refers to the selected cell, e.g.: =D3=ROUND(D3,1) (optional) Add an Input Message and/or an Error Alert Click OK Tracy wrote: I want to restricted cell input to 1 delimal place ie 77.9. if user tries to input 77.09 or 77.48 or any figure to two decimal place they are prevent and must put in ie 77 or 77.4. Any ideas -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel | |||
How do I convert decimal inches to fractions in excel | Excel Discussion (Misc queries) | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
EXCEL Decimal changes during WORD Merge | Excel Discussion (Misc queries) |