| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula results display only after pressing Enter key
I import data from a database as a csv file and then save it as an Excel 2003
workbook. The first column in the spreadsheet contains a long list of four character entries. I remove the first character of each entry by inserting a column next to Column A and using the following formula: =right(A1, LEN(A1)-1) Usually, I can copy or drag the formula to the following cells in the inserted column and the formula results are displayed. However, today, when I copy the formula to the other cells, the results for Column B1 are copied to all the cells in Column B. When I look at the formula in each of those cells, the formula has incremented [right(A2, LEN(A2)-1)], but the contents displayed do not increment until I press the Enter key. How can I get the formulas to execute without having to click Enter in each cell? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula results display only after pressing Enter key
rmdbolton wrote:
I import data from a database as a csv file and then save it as an Excel 2003 workbook. The first column in the spreadsheet contains a long list of four character entries. I remove the first character of each entry by inserting a column next to Column A and using the following formula: =right(A1, LEN(A1)-1) Usually, I can copy or drag the formula to the following cells in the inserted column and the formula results are displayed. However, today, when I copy the formula to the other cells, the results for Column B1 are copied to all the cells in Column B. When I look at the formula in each of those cells, the formula has incremented [right(A2, LEN(A2)-1)], but the contents displayed do not increment until I press the Enter key. How can I get the formulas to execute without having to click Enter in each cell? Set Calculation to Automatic. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change direction when pressing enter | Excel Discussion (Misc queries) | |||
| HOW DO I GET THE ANSWER TO A FORMULA BY PRESSING ENTER IN CELL? | Excel Discussion (Misc queries) | |||
| WYA Converts to WAY after pressing enter ket | Excel Discussion (Misc queries) | |||
| Pressing Enter Key | Setting up and Configuration of Excel | |||
| select the first cell in the next row down after pressing enter o. | Setting up and Configuration of Excel | |||
Linear Mode
