Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected Worksheet, Cell Formatting Lost on Double Click?
Hi All,
I have a worksheet with a cell on it which is formatted as a %. If I protect the sheet and single click the cell to enter a new value, I type 5 and 5.00% is entered, if I double click the cell to enter a new value and I type 5, 500.00% appears, it's like it loses its formatting. I wouldn't double click the cell but I have put together an entry form for my dad and his colleagues and some of them are stuck in their ways to double click the cells! Any ideas how I can overcome this? Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected Worksheet, Cell Formatting Lost on Double Click?
If you have double clicked, you must enter the decimal equivalent of the
percent.or add the percent sign: either .05 or 5% Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Louise" wrote in message ... Hi All, I have a worksheet with a cell on it which is formatted as a %. If I protect the sheet and single click the cell to enter a new value, I type 5 and 5.00% is entered, if I double click the cell to enter a new value and I type 5, 500.00% appears, it's like it loses its formatting. I wouldn't double click the cell but I have put together an entry form for my dad and his colleagues and some of them are stuck in their ways to double click the cells! Any ideas how I can overcome this? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel does nothing when I double-click on password protected file | Excel Discussion (Misc queries) | |||
Double click to navigate to a cell | Excel Discussion (Misc queries) | |||
Help please, cell formatting only works after I double click the cell | Excel Worksheet Functions | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Double click in a Cell | Excel Discussion (Misc queries) |