Posts

Ubah format NPWP di Excel

cara merubah format NPWP pada microsoft excel
NPWP > UBAH FORMAT > RUMUS

123456789529000 > 12.345.678.9-529.000 > =LEFT(A2;2)&"."&MID(A2;3;3)&"."&MID(A2;6;3)&"."&MID(A2;9;1)&"-"&MID(A2;10;3)&"."&RIGHT(A2;3)

123456789529000 > 123456789-529.000 > =LEFT(A3;9)&"-"&MID(A3;10;3)&"."&RIGHT(A3;3)

12.345.678.9-529.000 > 123456789529000 > =LEFT(A4;2)&MID(A4;4;3)&MID(A4;8;3)&MID(A4;12;1)&MID(A4;14;3)&RIGHT(A4;3)

12.345.678.9-529.000 > 123456789-529.000 > =LEFT(A5;2)&MID(A5;4;3)&MID(A5;8;3)&MID(A5;12;1)&MID(A5;13;5)&RIGHT(A5;3)

123456789-629.000 > 12.345.678.9-629.000 > =LEFT(A6;2)&"."&MID(A6;3;3)&"."&MID(A6;6;3)&"."&MID(A6;9;1)&"-"&MID(A6;11;3)&"."&RIGHT(A6;3)

123456789-629.000 > 123456789629000 > =LEFT(A7;9)…

Aspek Perpajakan Artis Seniman Penari Musisi

Aspek Perpajakan Partai Politik

Slide Aspek Perpajakan Makelar Broker Jasa Perantara Freelance