Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Numbers stored as Text to Numbers
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.- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Numbers stored as Text to Numbers
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 clickPasteSpecial --Select 'Add' and click OK. Another way to convert the cells to numerics do the below. In 2003 ToolsOptionsError checking'Number stored as text' In 2007 OfficeButtonExcelOptionsFormulasError 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.- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Numbers stored as Text to Numbers
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 "Emece" wrote in message ... 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.- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers stored as text to numbers | Excel Discussion (Misc queries) | |||
Convert numbers stored as text to numbers | Excel Discussion (Misc queries) | |||
convert numbers stored as numbers to text | Excel Worksheet Functions | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) |