copy the thousand number only

**choy96** · 03-30-2010, 03:39 AM

need a formula that can be copy the thousand number only.
example:

if A1 is 123456, B1 will be display 123kpcs
if A1 is 1234567, B1 will be display1234kpcs

thanks in advance

**JeanRage** · 03-30-2010, 03:55 AM

Hi,

You can use format custom ...
make sure to indicate your separator ... such as '

Please Login or Register  to view this content.

HTH

**estige** · 03-30-2010, 04:46 AM

Or if you want the result to be text:

Please Login or Register  to view this content.

**teylyn** · 03-30-2010, 06:35 AM

estige, with =TRUNC(A1/1000) you are changing the number value. Concatenating with text converts the number into text. It is then no longer available for calculation.

Formatting the number has the same visual effect, does not require a calculation and preserves the number as a number for other mathematical operations.

I'd always go for the format option, unless a text conversion is required.