I have imported a column with numbers, but the cells are formatted as text.
How do I convert them to Numbers?

Thanks in advance

Regards,
Emece.-

You can easily convert these cells to numeric format if you have enabled
error checking for these cells. Another work around is

--Copy a blank cell
--Keeping the copy select the range of cells with numeric values
--Right click>PasteSpecial>
--Select 'Add' and click OK.

Another way to convert the cells to numerics do the below.
In 2003 Tools>Options>Error checking>'Number stored as text'
In 2007 OfficeButton>ExcelOptions>Formulas>Error checking>

--If you have this option checked; then error checking is enabled for such
cells.
--For cells with numeric value but formatted as text; on the left top corner
of the cell you will see a green triangle.
--Select the range of cells and make sure one of the cells with the green
triangle is the active cell (cell with white background).
--Click/dropdown on the error information popup which is displayed towards
the left of the active cell
--Select 'Convert to number'


Regards
Jacob


"Emece" wrote:

> I have imported a column with numbers, but the cells are formatted as text.
> How do I convert them to Numbers?
>
> Thanks in advance
>
> Regards,
> Emece.-

I sometimes use this assigned to a custom button on the toolbar

Sub fixmynums()
Application.ScreenUpdating = False
On Error Resume Next
For Each c In Selection
If Trim(Len(c)) > 0 And c.HasFormula = False Then
c.NumberFormat = "General"
c.Value = CDbl(c)
End If
Next

Application.ScreenUpdating = True
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Emece" <(E-Mail Removed)> wrote in message
news:4C9DD6B9-F291-4FF6-9BDC-(E-Mail Removed)...
>I have imported a column with numbers, but the cells are formatted as text.
> How do I convert them to Numbers?
>
> Thanks in advance
>
> Regards,
> Emece.-