Mo,

You don't need to use conditional formatting: just use a custom number format. From Help:



Replace the format for zeroes with "'#0"', or ""'#0"'," I'm not sure which will geive you
your desired results.

HTH,
Bernie
MS Excel MVP


"Mo2" wrote in message
...
IF Cell value = 0, wrap with quotes
not exactly quotes.. but with this number format: ""'#0"',"
wrapped in single quotes, followed by a comma.

(format-cells - costum , to see what it looks like)


also, i dont want it to apply to every column (if its possible to do that)
just A1:A323, B1:B323, E1:E323, G1:G323, I1:I323, K1:K323

thanks in advance