| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I refresh cells after changing the format?
Cells do not automatically change when the number format is changed. You
have to edit the cell and resave before the new format takes effect. Try it...if you change a range from General format to text format, the cells will not indicate a format change until you open each cell with F2 and press enter. Is there an easy way to globally refresh a range of cells that have had a format change? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut to refresh format cells | Excel Worksheet Functions | |||
| Changing a cells format (Time) | Excel Discussion (Misc queries) | |||
| Keeping the format when refresh on the pivot chart | Charts and Charting in Excel | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| How can I keep a cells format, general, from changing after enter. | Excel Discussion (Misc queries) | |||
Threaded Mode
