Precis Numbers

[Rodney]

A3 is the result of A1/21
I want to bracket the number in A4
In MSWorks I would type the statement
="["&string(A3,0)&"]"

In excel I get in some cells [1.436871259834]
I'd like it to read [1]

Help please.

 

[Bernie Deitrick]

Rodney,

="["&ROUND(A3,0)&"]"

 

[Rodney]

Many thanks Bernie.

| Rodney,
| ="["&ROUND(A3,0)&"]"
HTH,
| Bernie
| MS Excel MVP