| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell requires double click to 'activate' date format change
I have saved a file from quickbooks into excel. when I open the report, the
dates in my transaction date column are in text format. When I change the column to date format, nothing happens until I double click in each cell. It is as if I have to enter the cell and leave it to 'activate' my command to change date formats. this will not do of course, because I have thousands of rows. how do I get them to all update when I change the format? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change display format - double click for precedent cells? | Excel Discussion (Misc queries) | |||
| How to change syperlink from single click to double click | Excel Worksheet Functions | |||
| Zip + 4 format column then must double click to change - why? | Excel Discussion (Misc queries) | |||
| double click a cell with Date format | Excel Discussion (Misc queries) | |||
| Cell contents with custom time format rounded after double-click | Excel Discussion (Misc queries) | |||
Threaded Mode
