changing formats

[Bob Webber]

How do I change a positive integer that has been entered
in text format to numeric format? I can go from numeric
to text, but not from text to numeric. Thanks.

 

[Frank Kabel]

Hi Bob
are you looking for the function VALUE(text) ?

Frank

 

[Norman Harker]

Hi Bob!

Try:

Select an empty cell,
Copy
Select the "text numbers"
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.