Text to number

M

melle

:rolleyes: I copied some values from an email (like 1.2334, 1.567673
etc.) into excel.

If I click on a cell and click on "Format cells" and I click on numbe
and 2 decimal places. It does not work. The value keeps 6 decima
places.

Does someone have a solution for this.

Kind Regards,

Mell
 
J

Jerry W. Lewis

Formatting changes only the disply, not the value of the cell. In
particular, it will not convert a text value into a numeric value. To
do that conversion, either
1. select the cell, format as a number, put the cursor in the formua bar
above, and press enter.
2. copy a blank cell, select cell in question and Edit|Paste Special|Add

Jerry
 
R

Ruffed Grouse

If you have a lot of #'s pasted into Excel, you might want to make use
of the =VALUE() function in an adjacent column, which will convert your
text "numbers" into real numbers.
 
H

Harlan Grove

Jerry W. Lewis wrote...
Formatting changes only the disply, not the value of the cell. In
particular, it will not convert a text value into a numeric value. To
do that conversion, either
1. select the cell, format as a number, put the cursor in the formua bar
above, and press enter.
2. copy a blank cell, select cell in question and Edit|Paste Special|Add ....
Click to expand...
....

If the 'numbers' in question came from a formatted HTML source, which
is possible when coming from e-mail, they could include trailing
nonbreaking spaces (decimal char code 160). If so, neither solution
above would change such text values to numbers.

One alternative that would handle this (as well as the case of no
trailing nonbreaking spaces or trailing normal spaces) is using Data >
Text to Columns, use the Delimited option, check the Other checkbox and
in the entry box to the right of it hold down an [Alt] key, press 0 1 6
0 in sequence on numeric keypad (this won't work using the number keys
above the QWERTY keys), release the [Alt] key, and click on Finish.
 
Top