Logo GNT
Actualités Tests & Guides Bons Plans
GTA 6 iPhone 17 Copilot Switch 2 Temu ChatGPT Tesla
OVH Cloud OVH Cloud
Entraide Applications Microsoft Office Excel mconcat----- concatate

mconcat----- concatate

3 réponses
Avatar
alexanderd
i have a problem with this function in that when i concatenate two colums of
figure say "0031587" & "0018"
the first two ZERO'S in "0031587" are removed in some cases ther are 6figres
precede by i zero.

what should i do to keep the original formating when using this function so
that i end up with "00315780018" and not "315780018"


--
alexanderd
Signaler un problème avec ce contenu

3 réponses

Supprimer
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire

Veuillez sélectionner un problème

Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Avatar
lSteph
hello, you to, "alexanderd"
and however "thanks a lot"!

See personal's formatings
"00000000000"

The french robotname is a human one!

Is'nt'it wonderfull?

cu

'lSteph




a écrit dans le message de news:

i have a problem with this function in that when i concatenate two colums
of
figure say "0031587" & "0018"
the first two ZERO'S in "0031587" are removed in some cases ther are
6figres
precede by i zero.

what should i do to keep the original formating when using this function
so
that i end up with "00315780018" and not "315780018"


--
alexanderd


Avatar
Bob Phillips
=TEXTE(A1,"0000000")&TEXTE(B1,"0000")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"alexanderd" wrote in message
news:
i have a problem with this function in that when i concatenate two colums
of

figure say "0031587" & "0018"
the first two ZERO'S in "0031587" are removed in some cases ther are
6figres

precede by i zero.

what should i do to keep the original formating when using this function
so

that i end up with "00315780018" and not "315780018"


--
alexanderd


Avatar
alexanderd
great works a treat

thank you for your help
--
alexanderd


"Bob Phillips" wrote:

=TEXTE(A1,"0000000")&TEXTE(B1,"0000")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"alexanderd" wrote in message
news:
i have a problem with this function in that when i concatenate two colums
of

figure say "0031587" & "0018"
the first two ZERO'S in "0031587" are removed in some cases ther are
6figres

precede by i zero.

what should i do to keep the original formating when using this function
so

that i end up with "00315780018" and not "315780018"


--
alexanderd