Formatting macro required

P

pcor

I would like a macro that will format any selecred cell : It should
format as a NUMBER of 2 decimals
Thanks
 
D

Don Guillett Excel MVP

Activecell.Numberformat = "#,#00.00"

--

HTH

Bob






- Show quoted text -
Click to expand...

If you want it to be truly automatic, put within a
worksheet_selectionchange event macro in the sheet module.
 

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 does not accept text format! 0
Macro to copy table of contents to a new doc 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Change a great number of words in word files, with a macro as short as possible. 5
Macro warning in word 1
How to count the numbers in a Word document? 0
Difficulty with compatibility mode and Track Changes 2
Converting URLs in comments to Markdown-formatted links 2

Top