Perhaps you might want to try these 2 responses by Dave Peterson & Peo as
well:
http://tinyurl.com/7vbw3
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Stan" wrote in message
...
Can I have zero format with a slash through it? If I mix numbers (digits)
with letters in a cell I want to be able to distinguish zeros from Os with
a
slash. Example: ABCD000438NOPQ (zeros and Os in same cell).