How to force number formats ?

M

Milind

My file has various cells filled with computed values, of different number
formats. But even after specifying them like,

Range( ...).Select
Selection.NumberFormat = ...

I find only one to two out of around six instructions are adhered to. I even
tried first selecting whole sheet, applying "Number" format, deselecting and
then applying other formats in turn of their appearance, but of no avail.
Any ideas ?

Milind
 

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

How to change font & size of (all) citation numbers? 7
Macro to Format Multiple Sheets based on "Master" Format 0
Apply cell formatting using VBA 2
Border formatting row of cells 22
Conditional Formatting macro: simple, but doesn't work 6
Paste a conditional format without replacing existing formats?? 4
Inconsistent behavior when applying conditional formats 3
Formatting cells within VBA 3

Top