Overview Chat Bike Members News Women
Viewing 5 posts - 1 through 5 (of 5 total)
  • Excel 'special text'
  • LabMonkey
    Free Member

    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 11 years ago
    thisisnotaspoon
    Free Member

    =”[“&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 11 years ago
    LabMonkey
    Free Member

    Well that looks easier than I expected – Thanks!

    Posted 11 years ago
    Craggyjim
    Free Member

    or select the cell, right click format and enter \[#\] in the special format box.

    Posted 11 years ago
    Craggyjim
    Free Member

    Sorry, I meant Custom box not special.

    Posted 11 years ago
Viewing 5 posts - 1 through 5 (of 5 total)

The topic ‘Excel 'special text'’ is closed to new replies.

Overview Chat Bike Members News Women