If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing Of Column Values ?
Hello,
Using Excel 2007 and Windows7 This sure seems "funny," and was hoping someone might explain it for me: In B1 I have the value 154.22 In B2 I have the value 33.74 In E1 I have 154000000 In E2 I have 33740000 I copy from Column E, and do a Paste Special in Column B Column B looks correct, as it has in: B1 the value 154220000 B2 the value 33740000 But- E1 has changed to 1.5422E+14 E2 has changed to 3.374E+13 In the Paste Special dialog box that came up I selected for Paste: Values, and Operation: None As the values in B look correct, I'm satisfied. The values in column E, with the incredibly large exponent, e.g., the E+14, were meant to be deleted after the Copy and Paste Special anyway. But why have they (column E)changed to such a large value ? I find this very disturbing, and would like to understand what happened. Thanks, Bob |
#2
|
|||
|
|||
Changing Of Column Values ?
Make column B wide enough to display 154220000 in it and it probably won't
change to scientific notation format. "Bob" wrote: Hello, Using Excel 2007 and Windows7 This sure seems "funny," and was hoping someone might explain it for me: In B1 I have the value 154.22 In B2 I have the value 33.74 In E1 I have 154000000 In E2 I have 33740000 I copy from Column E, and do a Paste Special in Column B Column B looks correct, as it has in: B1 the value 154220000 B2 the value 33740000 But- E1 has changed to 1.5422E+14 E2 has changed to 3.374E+13 In the Paste Special dialog box that came up I selected for Paste: Values, and Operation: None As the values in B look correct, I'm satisfied. The values in column E, with the incredibly large exponent, e.g., the E+14, were meant to be deleted after the Copy and Paste Special anyway. But why have they (column E)changed to such a large value ? I find this very disturbing, and would like to understand what happened. Thanks, Bob . |
Thread Tools | |
Display Modes | |
|
|