Formatting text as numbers

  • Thread starter Thread starter Don Niall
  • Start date Start date
D

Don Niall

Hi,

I have viewed a s/s in HTML format ......... There's an
option to export the file to Excel, which I have done.
However, the numbers do not appear to be formatted
correctly ........... I have tried changing the format of
the values to number - however it doesn't work?
Yet if I go on the individual cell, an exclamation mark
appears on the left informing me that it is formatted as
text - rather than number. If I change using this
capability it works?

Is there some way I can select all the values and change
the formatting en masse.

Don
 
To convert a column of purely "text" numbers
to "numerical" values you should use the VALUE worksheet
function in an empty column.
As is,
=VALUE(A1)

However, to convert a mixed column of data with actual
text and numbers, then you should employ a conditional
formula.
As is,
=IF(ISERR(VALUE(A1)),A1,VALUE(A1))
 
Don,
I set up another column and entered the formula +[subj col]
+0, and then copied the formula to all cells in the
column. Then the if function interpreted the new result
as a number, which it had not done with the original
number.
Paul
 
Back
Top