How to format cells to General via vba

S

Simon

Some cells are pasted in from external sources as a date. I used the
record and play option but it didn't pick up how to format cells as
General.

How is this possible?

Thanks
 

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

VBA Change Format of All Cells in a Workbook 4
Determine cells with "General" number format 5
bizarre formatting issue 10
Changing number format to remove % 2
Format change with VBA language dependent? 5
Remove date format? 3
Curious general format rounding 2
Format Cells with VBA? 1

Top