| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Truncate a data entry cell
I would like to truncate a cell as the user is entering data. All the number
formating techiques round the data up to the next value but I just want to truncate it. I see the formula =TRUNC(A1,4) will work but I cannot figure out how to use the formula as a format. If the user is entering data into A1, it will change A1's format to number when they enter data. Any help will be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Control Data Entry - push entry to next cell | Excel Discussion (Misc queries) | |||
| Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| Truncate within a cell | Excel Worksheet Functions | |||
| truncate the yaxis if one data point is MUCH higher than the rest | Charts and Charting in Excel | |||
Threaded Mode
