Using VBA macro to add star (*) to end of cell using NumberFormat [duplicate]

Question

All,

I have a macro I use to mark up tables of analytical data. For one specific situation I want to add a "*" to the end of the cell without affecting it's value, which can be done using a custom NumberFormat.

To do this manually you can type General" *" into the custom number format field.

I can't figure out how to do this with VBA.

I tried these, but they didn't work:

cell.NumberFormat = "General" *""
cell.NumberFormat = "General\*"

Any suggestions?

Thanks!

The result you're trying to get to will be entering General " *" into the cell. You need to differentiate between the " symbols that are part of the final string, and the " symbols that enclose the string as a whole. To do that, you need to double up the "s, so you'll need to enter "General"" *""" — Werrf
– Werrf, Commented Apr 14 at 19:47
Thanks to both of you! I thought I was close. So frustrating! — codenewb
– codenewb, Commented Apr 14 at 19:58

codenewb · Accepted Answer · 2025-04-14 19:59:24Z

0

Then answer is to use

"General"" *""

answered Apr 14 at 19:59

codenewb

1072 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using VBA macro to add star (*) to end of cell using NumberFormat [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related