Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Zero with a slash
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). |
#2
|
|||
|
|||
Excel already distinguishes between 0 and O as you can see here. Zero is
elliptical and O is a circle. -- Ken Russell Remove yourhat to reply by e-mail .. "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). |
#3
|
|||
|
|||
it's a font choice:
some fonts are bad for your purpose, just try many the one you asked is 8514oem but a lot of others make the digit 0 and the letter O easy to distinguish: Terminal, Fixed Size, ... |
#4
|
|||
|
|||
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). |
#6
|
|||
|
|||
That may look nice, but any arithmetic will fail.
(or comparisons with numbers that contain 0's) DNA wrote: You could key ALT + 0216; hence Ø. -- Dave Peterson |
#7
|
|||
|
|||
That is excellent, thank you.
Stan "DNA" wrote: You could key ALT + 0216; hence Ø. |
#8
|
|||
|
|||
Dave,
No arithmetic will be performed using that cell. It is a reference number combining letters and digits. Less confusion if the zero has a slash. Thank you. Stan "Dave Peterson" wrote: That may look nice, but any arithmetic will fail. (or comparisons with numbers that contain 0's) DNA wrote: You could key ALT + 0216; hence Ø. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter a slash character in excel? | Excel Discussion (Misc queries) | |||
How can I put a slash in a zero in Office 97 | New Users to Excel | |||
replace command | Excel Discussion (Misc queries) |