Format text to general

S

Shane Devenshire

Hi Gator,

Do you mean that there are numbers entered as text and now you want to
format them to General? If you have text formatted as text or general they
will look and behave the same, the only issue is numbers and dates (which
are also numbers). To convert numbers stored as text to numbers, or to
convert dates stored as text to numbers which you can then format as you
choose:

Select an empty cell and copy it. Select all the items you want converted
and choose Edit, Paste Special, Add.

Cheers,
Shane Devenshire
Microsoft Excel MVP
 
G

Gary''s Student

1. select the column and:

Format > Cells... > Number . General

2. to "fix" the data, hilight the cells to be fixed and run:

Sub fixxer()
Dim cell As Range
For Each cell In Selection
cell.Value = cell.Value
Next
End Sub
 
Top