how to change

V

vivats

hi there, how can i change a text like '1234 to be a number? the problem is
that i couldn't change it into a number even i press the comma key or use
the "format cell" function. pls help. thanks
 
N

Norman Harker

Hi Vivats!

Select a blank cell
Copy
Select the "text number"
Edit > Paste Special > Add > OK


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
A

Arvi Laanemets

Hi

At first, independently of method you'll use, you have to ensure, that the
cell(s) format is General or Numeric.
Then, when the problem did occur with single cell only, select the cell in
Edit mode (double-click, or F2), in formula bar delete the preceeding
apostrophe, and press Enter.
When you have several such cells, enter 1 into some free cell (or find a
cell with number 1 in it) and copy it. Select the range to convert, and then
PasteSpecial.Multiply
 
V

vivats

how about change it into a value then?
Arvi Laanemets said:
Hi

At first, independently of method you'll use, you have to ensure, that the
cell(s) format is General or Numeric.
Then, when the problem did occur with single cell only, select the cell in
Edit mode (double-click, or F2), in formula bar delete the preceeding
apostrophe, and press Enter.
When you have several such cells, enter 1 into some free cell (or find a
cell with number 1 in it) and copy it. Select the range to convert, and then
PasteSpecial.Multiply


--
(When sending e-mail, use address [email protected])
Arvi Laanemets


problem
Click to expand...
 
Top