Convertin Text to numbers within a Macro??

  • Thread starter Thread starter Pedros
  • Start date Start date
P

Pedros

I am recording a Macro that involves and If statement. I want the macr
to then paste over the if statements with values (1 & 0). When I past
values over the if statement the cells are formatted as text an
although I highlight all of them and format cells as numbers in th
macro it doesn't seem to record the step.

How can I have these cells formatted as numbers within the macro??

thanks
 
Maybe:
Selection.NumberFormat = "0"
or
Selection.NumberFormat = "General"

Hope this helps
Rowan
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
Custom Number Format for text 8
problems getting this macro to work 23
macro or formula to paste values from one tab to another 1
@Sum Conditional Values within a Macro 1
Changing Text To Numbers ? 1
Multiple worksheet Copy Paste Macro 2
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0

Back
Top