Format Columns

[Guest]

Hi,

i am trying to write a macro that converts a column's format from text to
numeric with no decimal places.

Thanks

 

[Tom Ogilvy]

Columns(3).NumberFormat = "#"

But this will not affect any values that are stored as text.

Perhaps
Columns(3).NumberFormat = "#"
set rng = Range(cells(1,3),Cells(rows.count,3).end(xlup))
rng.Value = rng.Value

is what you want

 

[Martin_Austin]

I know to format a specific cell like that, you could use th
formatnumber() function. I'm new to this too, so I don't kno
specifics