Text to number

  • Thread starter Thread starter melle
  • Start date Start date
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
 
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
 
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.
 
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 ....
....

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.
 
Back
Top