Topic starter
Hello,
I have an excel cell that displays a number, for example 300.
I would like it to report this number in square brackets, eg. [300]
Is it possible to do this somehow?
Cheers!
Posted : 23/10/2012 4:26 pm
="["&A1& "]"
Where A1 either takes the value of A1 or you could put a formula in there. I usually use it to write sentences, eg the pumps NPSH is __m is ="the pumps NPSH is"%A1&"m"
Posted : 23/10/2012 4:30 pm
Topic starter
Well that looks easier than I expected - Thanks!
Posted : 23/10/2012 4:31 pm
or select the cell, right click format and enter \[#\] in the special format box.
Posted : 23/10/2012 4:32 pm
Sorry, I meant Custom box not special.
Posted : 23/10/2012 4:33 pm