How do I change 0 to a 0 with an oblique line through it.

**Rabbit** · Sep 25 '13, 05:37 AM

Switch to a font that does that.

**ADezii** · Sep 25 '13, 05:01 PM

If you want to get a little fancy, try:

Code:

Dim strBaseString As String

strBaseString = "00022377690870055431000HGRT0410"
Debug.Print Replace(strBaseString, "0", Chr$(216))

which will produce:

Code:

ØØØ2237769Ø87ØØ55431ØØØHGRTØ41Ø

**zmbd** · Sep 26 '13, 02:08 PM

just keep in mind that the "value" returned by ADezii is a STRING and not a NUMERIC
(I know it seems obvious (-,-) )

Comment