Numberformat with many columns at one go

[SamDsouza]

Hello

I want to numberformat with many columns at one go

Can i

ws.Columns(3, 5, 9, 11, 23, 27).NumberFormat = Trim(Replace(Format(String(Len(Int([B][COLOR=#ff0000]Cell.value[/COLOR][/B])) - 1, "#"), " @@\\,@@\\,@@\\,@@\\,@@\\,@@\\,@@0"), " \,", "")) & ".00"

Also Cell.value in red requires proper syntax
Will the above format round off if "No" then how can i round off


Thanks
SamD

 

[SamDsouza]

Thanks Rick. Really Appreciate your timely response. My query for Rounding off was to Post #5 by PGC01

 

[Rick Rothstein]

Thanks Rick. Really Appreciate your timely response. My query for Rounding off was to Post #5 by PGC01

Pretty much a similar approach... just remove the .00 off the end of each of PGC01's assignments to each of those NumberFormat patterns.

 

[SamDsouza]

Yes Rick removed ".00" . Yes As desired i got. Thankx a tonne