Cell programming question
 

After shrinking a number that looks like this 1.76082312808723 down to 1.761
by formatting to 3 decimal places, I need to add a [b] on the end but it
bounced back to 1.76082312808723[b].
What do I need to do to the cell so it looks like 1.761[b] or something very
very close?

I have a huge list of numbers and I'm going to have to replace the "b" in
pretty much every number with an "a"or a "c" on most numbers.

Cell programming question
 

A1 = 1.76082312808723
Try this

=ROUND(A1,3)&"[b]"

If this post helps click Yes
---------------
Jacob Skaria


"gmfod" wrote:

After shrinking a number that looks like this 1.76082312808723 down to 1.761
by formatting to 3 decimal places, I need to add a [b] on the end but it
bounced back to 1.76082312808723[b].
What do I need to do to the cell so it looks like 1.761[b] or something very
very close?

I have a huge list of numbers and I'm going to have to replace the "b" in
pretty much every number with an "a"or a "c" on most numbers.

Cell programming question
 

To format the entire column to the same [b]

Format Cells|Custom.. Enter 0.000"[b]"

If this post helps click Yes
---------------
Jacob Skaria


"gmfod" wrote:

After shrinking a number that looks like this 1.76082312808723 down to 1.761
by formatting to 3 decimal places, I need to add a [b] on the end but it
bounced back to 1.76082312808723[b].
What do I need to do to the cell so it looks like 1.761[b] or something very
very close?

I have a huge list of numbers and I'm going to have to replace the "b" in
pretty much every number with an "a"or a "c" on most numbers.