how to change

  • Thread starter Thread starter vivats
  • Start date Start date
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
 
Hi Vivats!

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


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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
 
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 (e-mail address removed))
Arvi Laanemets


problem
Click to expand...
 
Back
Top