Diable # in Excel Workbook Cells

[Former Member]

Hello,

can I disable displaying all the '#' Values in Excel-Workbooks.

I would like to have empty cells instead.

Thx!

cu

Dominik

[Former Member]

Hi - thanks for your answers.

I already do this by a macro - but it is very slow due to a number of a minimum of 24000 cells i have to clean in my workbook.

I takes about 2 Minutes to clean all # merge three textfield an overwrite another one

cu

Dominik

[Former Member]

Hello

I think you may have the possibility to change this character by another one. There must be a transaction for that, I've done this in the past.

I forgot this transaction.

We use it to get rid of "n/DIV0" from our reports.

C.

[Former Member]

See if below thread helps -

[Former Member]

If you wan to disable # you can restrict that value for a particular char and exclude that from selection but if you want blank you can write small code since you have already created workbook. Trigger a small macro....as said in above post....

[Former Member]

Hi,

If there is no value available then by default "#" will be displayed in excel. If you need to replace "#" by blank value then you need to write a macro in excel..

Hope this helps.