| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entry of data in formula bar ignores cell percentage formatting
Hello --
My user was complaining that entering a percentage in a percentage-formatted cell was resulting in 100 times the value he entered. His method of entry was to enter the value in the formula bar while the target cell was hilighted (does not seem like an efficient way to enter data) which appears to ignore the cell format: Number Percentage. But ... the customer is always right. Is there a way to have the cell formatting apply when cell data entry is via the formula bar? Thanks for any help. Larry Mehl |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage data with one entry extremely high | Charts and Charting in Excel | |||
| Formula and or data entry into cell? | Excel Worksheet Functions | |||
| want to make a formula for a data entry in the same cell in excel | Excel Discussion (Misc queries) | |||
| Excel formula timestamp for a data entry of a referenced cell | Excel Worksheet Functions | |||
| Formula and Data Entry in a Single Cell | Excel Discussion (Misc queries) | |||
Threaded Mode
