Format de cellule personnalisée

%3CLINGO-SUB%20id%3D%22lingo-sub-3353662%22%20slang%3D%22fr-FR%22%3ECustom%20cell%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3353662%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20not%20customize%20the%20column%20of%20cells%20where%20there%20are%20numbers%2C%20I%20would%20like%20to%20transform%20them%20into%20%2B41%20xx%20xxx%20xx%20xx%20xx%20but%20it%20does%20not%20register%20when%20I%20do%20the%20manipulation%20in%20custom%20number%20%26gt%3B%20%26gt%3B%20type%20%22%2B%22%2000%2000%20000%2000%2000%20%2C%20the%20manipulation%20does%20not%20work.%3C%2FP%3E%3CP%3EHow%20to%20do%20it%20please%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture%20d%E2%80%99%C3%A9cran%20(167).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370577i4CE097159BFC7E64%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture%20d%E2%80%99%C3%A9cran%20(167).png%22%20alt%3D%22Screenshot%20(167).png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture%20d%E2%80%99%C3%A9cran%20(169).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370578iD91B69B5E61AF109%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture%20d%E2%80%99%C3%A9cran%20(169).png%22%20alt%3D%22Screenshot%20(169).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3353662%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3353861%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20de%20cellule%20personnalis%C3%A9e%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3353861%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386340%22%20target%3D%22_blank%22%3E%40Marjorie_Kugel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELes%20valeurs%20de%20la%20colonne%20N%20sont%20des%20valeurs%20textuelles%20et%20non%20des%20nombres.%3C%2FP%3E%0A%3CP%3EIl%20faut%20convertir%20les%20valeurs%20en%20nombres%20avant%20d%C3%A9finir%20le%20format%20personnalis%C3%A9%3CBR%20%2F%3ED%C3%A9finissez%20le%20format%20num%C3%A9rique%20de%20la%20colonne%20N%20sur%20Standard.%3C%2FP%3E%0A%3CP%3ES%C3%A9lectionnez%20%3CSTRONG%20class%3D%22ocpLegacyBold%22%3EDonn%C3%A9es%20%3C%2FSTRONG%3E%26gt%3B%20%3CSTRONG%20class%3D%22ocpLegacyBold%22%3EConvertir%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3CP%3ES%C3%A9lectionnez%20%3CSTRONG%20class%3D%22ocpLegacyBold%22%3ETerminer%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3CP%3EPuis%20d%C3%A9finissez%20le%20format%20num%C3%A9rique%20de%20la%20colonne%20N%20sur%20le%20format%20personnalis%C3%A9%20%22%2B%22%2000%2000%20000%2000%2000%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3359791%22%20slang%3D%22fr-FR%22%3ERe%3A%20Custom%20Cell%20Format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3359791%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3EVogelaar%20%40Hans%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20why%20but%20I%20block%20the%20moment%20I%20get%20to%20%3CSTRONG%3Edata%20%26gt%3B%20convert%20%3C%2FSTRONG%3Esince%20there%20is%20a%20conversion%20wizard%20and%20I%20don't%20know%20how%20to%20continue....%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture%20d%E2%80%99%C3%A9cran%20(171).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370870i22AB9ED850A859D2%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture%20d%E2%80%99%C3%A9cran%20(171).png%22%20alt%3D%22Screenshot%20(171).png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture%20d%E2%80%99%C3%A9cran%20(173).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370869i436F84411AC82278%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture%20d%E2%80%99%C3%A9cran%20(173).png%22%20alt%3D%22Screenshot%20(173).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3359866%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20de%20cellule%20personnalis%C3%A9e%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3359866%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386340%22%20target%3D%22_blank%22%3E%40Marjorie_Kugel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EVous%20pouvez%20cliquer%20sur%20Terminer%20dans%20l'Assistant%20Conversion.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3359920%22%20slang%3D%22es-ES%22%3ERe%3A%20Format%20de%20cellule%20personnalis%C3%A9e%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3359920%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386340%22%20target%3D%22_blank%22%3E%40Marjorie_Kugel%3C%2FA%3E%26nbsp%3BHello%2C%20I%20do%20it%20as%20you%20in%20cell%20format%20as%20I%20show%20you%20in%20the%20image%20and%20if%20I%20modify%20it%2C%20I%20do%20not%20know%20what%20version%20of%20office%20you%20have%20I%20have%20365%2C%20I%20have%20seen%20that%20several%20things%20work%20differently%20according%20to%20the%20version%20of%20office.%3CBR%20%2F%3E%20This%20is%20how%20you%20type%20in%20the%20%22%2B%22%20cell%20format%2000%2000%20000%2000%2000%3C%2FP%3E%3CP%3EI%20hope%20it%20serves%20you%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Captura-duda%20excel.PNG%22%20style%3D%22width%3A%20937px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370874i742D536AD49ED7AA%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Captura-duda%20excel.PNG%22%20alt%3D%22Capture-doubt%20excel.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3361056%22%20slang%3D%22fr-FR%22%3ERe%3A%20Custom%20Cell%20Format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3361056%22%20slang%3D%22fr-FR%22%3E%3CP%3Eit%20doesn't%20want%20to%20take%20the%20format%20%2B41%20XX%20XXX%20XX%20XX....%20it%20automatically%20recovers%20as%20in%20the%20photo%20%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture%20d%E2%80%99%C3%A9cran%20(174).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370970i206D9FAE11D5381F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture%20d%E2%80%99%C3%A9cran%20(174).png%22%20alt%3D%22Screenshot%20(174).png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture%20d%E2%80%99%C3%A9cran%20(175).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370971i6B2B03D81B603C7B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture%20d%E2%80%99%C3%A9cran%20(175).png%22%20alt%3D%22Screenshot%20(175).png%22%20%2F%3E%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3361114%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20de%20cellule%20personnalis%C3%A9e%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3361114%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386340%22%20target%3D%22_blank%22%3E%40Marjorie_Kugel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EN4%20est%20correct%20-%20ou%20pas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Bonjour,

 

Je n'arrive pas à personnaliser la colonne de cellules où se trouvent des nombres, je voudrais les transformer en +41 xx xxx xx xx mais ça ne s'enregistre pas lorsque je fais la manipulation dans nombre > personnalisée > type "+" 00 00 000 00 00 , la manipulation ne marche pas.

Comment faire svp ?

Capture d’écran (167).pngCapture d’écran (169).png

6 Replies

@Marjorie_Kugel 

Les valeurs de la colonne N sont des valeurs textuelles et non des nombres.

Il faut convertir les valeurs en nombres avant définir le format personnalisé
Définissez le format numérique de la colonne N sur Standard.

Sélectionnez Données > Convertir.

Sélectionnez Terminer.

Puis définissez le format numérique de la colonne N sur le format personnalisé "+" 00 00 000 00 00

@Hans Vogelaar 

Je ne sais pas pourquoi mais je bloque au moment où j'arrive à données > convertir puisqu'il y a un assistant de conversion et je ne sais pas continuer....Capture d’écran (171).pngCapture d’écran (173).png

@Marjorie_Kugel 

Vous pouvez cliquer sur Terminer dans l'Assistant Conversion.

@Marjorie_Kugel Hola, yo lo realice como tú en formato de celda como te muestro en la imagen y sí me lo modifico, no se que versión de office tengas yo tengo 365, he visto que varias cosas funcionan diferentes según la versión de office.
Así  escribi en el formato de celda "+" 00 00 000 00 00

Espero te sirva
Captura-duda excel.PNG

ça ne veut pas prendre le format +41 XX XXX XX XX....ça se remet automatiquement comme sur la photo Capture d’écran (174).pngCapture d’écran (175).png@Hans Vogelaar 

@Marjorie_Kugel 

N4 est correct - ou pas?