convert to number

Copy an empty cell.
select your column
edit|paste special|check Add

or

Select your column
data|text to columns|finish.

Duncan_J wrote:
>
> I have a coulmn of numbers that need converted to numbers. The format cell
> won't work... You highlight all the numbers and the little ! box comes on and
> you click convert to number. However, it does not record that function in a
> macro.. I need to do this as it is part of a vlookup macro...
> Thanks,
> DJ

--

Dave Peterson

Thanks for the help!
Both worked...
DJ

"Dave Peterson" wrote:

> Copy an empty cell.
> select your column
> edit|paste special|check Add
>
> or
>
> Select your column
> data|text to columns|finish.
>
> Duncan_J wrote:
> >
> > I have a coulmn of numbers that need converted to numbers. The format cell
> > won't work... You highlight all the numbers and the little ! box comes on and
> > you click convert to number. However, it does not record that function in a
> > macro.. I need to do this as it is part of a vlookup macro...
> > Thanks,
> > DJ
>
> --
>
> Dave Peterson
>