Format text to general
 

How do I format a column entered originally as text to general?

Format text to general
 

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

"Gator" wrote in message
...
How do I format a column entered originally as text to general?

Format text to general
 

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
--
Gary''s Student - gsnu200803


"Gator" wrote:

How do I format a column entered originally as text to general?