Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need to be able to enter data in one of two ways, but have it result in the
same value. For example, I need to be able to enter the decimal number '11.22' as 11.22 or <-- I know how to do that :-) 1122 <-- and that :-) but in the end, the number needs to be understood as '11.22' So basically my problem is that I'm either stuck with one data entry method, or another, but I can't seem to find a way to use both in the same cell. I've toyed with the data validation feature, but I haven't found a way to make it do what I want. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I create a data entry edit mask? | Excel Discussion (Misc queries) | |||
Using a ComboBox for Data Entry into a Cell | Excel Worksheet Functions | |||
Data validation to prevent duplicate entry. | Excel Discussion (Misc queries) | |||
Formatting a worksheet for data entry | Excel Worksheet Functions | |||
possible to have =now() at data entry and not update after that? | Excel Worksheet Functions |