Cell Format
 

This is probably an easy one...and I'm sorry :)
No. BU # Amt.
? 21000 $15.00

I would like to format the no column to only bring over the first 4 numbers
from the BU column...
Is this possible?

Thanks in advance!!

Cell Format
 

Use the formula =LEFT(B2,4) and fill down in the No. column. This assumes
that BU# is in column B; adjust to suit your needs.

Dave
--
Brevity is the soul of wit.


"frustratedwthis" wrote:

This is probably an easy one...and I'm sorry :)
No. BU # Amt.
? 21000 $15.00

I would like to format the no column to only bring over the first 4 numbers
from the BU column...
Is this possible?

Thanks in advance!!

Cell Format
 

=--LEFT(B2,4)

Left() retutns a string - but the "--" converts it back to a number.
HTH


"frustratedwthis" wrote:

This is probably an easy one...and I'm sorry :)
No. BU # Amt.
? 21000 $15.00

I would like to format the no column to only bring over the first 4 numbers
from the BU column...
Is this possible?

Thanks in advance!!

Cell Format
 

Thank you.. That works beautifully :)

"Dave F" wrote:

Use the formula =LEFT(B2,4) and fill down in the No. column. This assumes
that BU# is in column B; adjust to suit your needs.

Dave
--
Brevity is the soul of wit.


"frustratedwthis" wrote:

This is probably an easy one...and I'm sorry :)
No. BU # Amt.
? 21000 $15.00

I would like to format the no column to only bring over the first 4 numbers
from the BU column...
Is this possible?

Thanks in advance!!

Cell Format
 

Thank you!! This works beautifully as well!! :)

"JMay" wrote:

=--LEFT(B2,4)

Left() retutns a string - but the "--" converts it back to a number.
HTH


"frustratedwthis" wrote:

This is probably an easy one...and I'm sorry :)
No. BU # Amt.
? 21000 $15.00

I would like to format the no column to only bring over the first 4 numbers
from the BU column...
Is this possible?

Thanks in advance!!