How to automatically change the visual value after changing number format?

[vonguyenphu]

I wrote a macro to change format of cell by adding pre-fix "19V". The format change under the hood but the value I see only change after I go to the cell and press Enter.
How to automatically change the visual value as well?

Selection.NumberFormat = """19V""@"

Eg: 12345 => 19V12345 (visual only, the actual value is still 12345)

 

[Peter_SSs]

Try this instead

Selection.NumberFormat = """19V""0"

 

[vonguyenphu]

Hi Peter,

That works, thks a lot.

 

[Peter_SSs]

Hi Peter,

That works, thks a lot.

You're welcome. Thanks for the follow-up.