show ++ instead of ##### in cells with values too large to display in cell

rodp

Board Regular
Joined
Mar 13, 2013
Messages
66
Hi All,

I'm looking for a solution which does not involve using a conditional (ie =If( ) formula in each and every cell to replace ###### with ++ when the number is too large to fit in the cell. It would be great if the solution could be a format under the special format section or a conditional format (although they are an absolute pain when it comes to large ranges) or some VB script (perhaps a script to go through each and every cell, detect if ###### and overlay a white box with ++ in - problem is this may get very messy if you are resizing and moving cells about and so you would need to be able to remove them and then reapply easily).

If anyone has any ideas, please let me know

Thanks in advance

Rodp

Pic below - if it doesn't show try loading it into a new tab.

 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,108,626
Messages
5,523,978
Members
409,549
Latest member
agus setiawan

This Week's Hot Topics

Top