Numeric

[Guest]

I have a column of figures which are not numeric type, how can I change to
numeric type by VBA.

Could someone please help. Thanks

 

[Bob Phillips]

Columns("E:E").Numberformat = "#,##0.00"

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Hello Bob,

First, I have to thank you for your reply.

Perhaps I should give more details about the problem. In fact, the content
(I don't know whether it is of numeric or text nature) is copied from a
web-site. When it is pasted on worksheet, there is a green triangle shown on
the upper left cornor asking for actions. What I need to do is to change it
to numbers. Could you please show me.

Thank you in advance for help.

"Bob Phillips" 來函：

 

[Dave Peterson]

You could try this manually:

Select an empty cell
edit|copy
Select the range to fix
edit|paste special|check values and add (both)

If that fixes the problem and you really need a macro, then record a macro when
you do it manually.

But...

Copying from web pages can be a problem. Sometimes what looks like a space
character isn't really a space character--it's one of those HTML non-breaking
spaces.

David McRitchie has a macro that cleans up this kind of stuff:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm