SOLVED

Formatos personalizados

%3CLINGO-SUB%20id%3D%22lingo-sub-2839384%22%20slang%3D%22es-ES%22%3ECustom%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2839384%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CEM%3EIf%20they%20wanted%20to%20make%20a%20custom%20format%20where%201%20means%20%22Very%20High%22%2C%202%20%22High%22%2C%203%20%22Medium%22%2C%204%20%22Low%22%20and%205%20%22Very%20Low%22%2C%20as%20they%20would%20do%2C%20because%20I%20can%20only%20do%20it%20with%203%20data%2C%20but%20with%20the%205%20no.%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2839384%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2839622%22%20slang%3D%22es-ES%22%3ERe%3A%20Custom%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2839622%22%20slang%3D%22es-ES%22%3EI%20thank%20you%20very%20much%2C%20but%20the%20formats%20I%20refer%20to%20are%20the%20custom%20formats%20of%20numbers%20but%20putting%20text%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2839453%22%20slang%3D%22en-US%22%3ERe%3A%20Formatos%20personalizados%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2839453%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1183548%22%20target%3D%22_blank%22%3E%40MasterBMN%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20the%20CHOOSE()%20formula.%20Find%20attachment%3CBR%20%2F%3E%3DCHOOSE(A1%2C%22Very%20High%22%2C%22High%22%2C%22Medium%22%2C%22Low%22%2C%22Very%20Low%22)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JulianoPetrukio_0-1634067421880.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F316875i03FF96FB0190045F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JulianoPetrukio_0-1634067421880.png%22%20alt%3D%22JulianoPetrukio_0-1634067421880.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2839688%22%20slang%3D%22en-US%22%3ERe%3A%20Formatos%20personalizados%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2839688%22%20slang%3D%22en-US%22%3ECan%20you%20send%20me%20some%20file%20with%20some%20examples%3F%20I%20didn't%20get%20it%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2842374%22%20slang%3D%22es-ES%22%3ERe%3A%20Custom%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2842374%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1183548%22%20target%3D%22_blank%22%3E%40MasterBMN%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20this%20is%20what%20you%20want%20to%20achieve%2C%20but%20I%20would%20not%20go%20the%20way%20of%20personalized%20formats%20of%20numbers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20if%20this%20solution%20helps%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2839929%22%20slang%3D%22en-US%22%3ERe%3A%20Formatos%20personalizados%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2839929%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1183548%22%20target%3D%22_blank%22%3E%40MasterBMN%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20understand%20what%20you%20meant%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20has%20limitations%20using%20those%20custom%20format%20as%20you%20can%20see%20below%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-visual-basic%22%3E%3CCODE%3E%5Bcondition%201%5Dcustom%20format%201%3B%5Bcondition%202%5Dcustom%20format%202%3Bother%20number%20format%3Btext%20format%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CBR%20%2F%3ESo%20I%20would%20suggest%20you%20some%20different%20approach.%3C%2FP%3E%3CP%3EFind%20attachment%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2842271%22%20slang%3D%22es-ES%22%3ERe%3A%20Custom%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2842271%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1183548%22%20target%3D%22_blank%22%3E%40MasterBMN%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20you%20can%20first%20put%20the%20dynamic%20table%20in%20classic%20view%20format%20and%20then%20you%20can%20add%20the%20field%20whose%20text%20you%20want%20to%20display%2C%20the%20effect%20may%20be%20similar%2C%20but%20it%20will%20not%20appear%20in%20values%20but%20in%20rows.%3C%2FP%3E%3CP%3EAnother%20option%20can%20be%20to%20index%20with%20unique%20values%20the%20concepts%20that%20you%20are%20interested%20in%20showing%20and%20linking%20with%20an%20array%20and%20look%20for%20those%20values%20to%20the%20text%20alq%20ue%20are%20associated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20I%20can%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3EJCH%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2839741%22%20slang%3D%22es-ES%22%3ERe%3A%20Custom%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2839741%22%20slang%3D%22es-ES%22%3EThanks%2C%20and%20attach%20a%20file%20in%20the%20question%2C%20I%20hope%20it%20is%20clearer%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2842169%22%20slang%3D%22es-ES%22%3ERe%3A%20Custom%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2842169%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767933%22%20target%3D%22_blank%22%3E%40Juliano-Petrukio%3C%2FA%3E%26nbsp%3BAnd%20if%20I%20wanted%20in%20a%20PivotTable%20to%20add%20in%20the%20values%20option%20a%20field%20but%20instead%20of%20showing%20me%20average%2C%20sum%20etc.%20show%20me%20the%20original%20values%20as%20the%20text%2C%20as%20I%20could%20do.%20According%20to%20me%20it%20only%20accepts%20to%20show%20numbers%20so%20try%20the%20custom%20formats%2C%20but%20if%20you%20know%20some%20other%20solution%20it%20would%20be%20useful.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Si quisieran hacer un formato personalizado en donde 1 signifique "Muy Alto", 2 "Alto", 3 "Medio", 4 "Bajo" y 5 "Muy Bajo", como le harían, por que solo logro hacerlo con 3 datos, pero con los 5 no.

8 Replies

@MasterBMN 

Use the CHOOSE() formula. Find attachment
=CHOOSE(A1,"Very High","High","Medium","Low","Very Low")

JulianoPetrukio_0-1634067421880.png

 

Te agradezco mucho, pero los formatos que me refiero son los formatos personalizados de números pero poniendo texto
Can you send me some file with some examples? I didn't get it
Gracias, ya adjunte un archivo en la pregunta, espero quede mas claro

@MasterBMN 

I understand what you meant now.

 

Excel has limitations using those custom format as you can see below

 

[condition 1]custom format 1;[condition 2]custom format 2;other number format;text format


So I would suggest you some different approach.

Find attachment

@Juliano-Petrukio Y si quisiera en una tabla dinámica agregar en la opción de valores un campo pero en vez de que me muestre promedio, suma etc. me muestre los valores originales como el texto, como le podría hacer. Según yo solo acepta mostrar números por eso intente lo de formatos personalizados, pero si sabes alguna otra solución sería útil.

best response confirmed by MasterBMN (Occasional Contributor)
Solution

@MasterBMN 

Quizas puedes primero poner la tabla dinamica en formato de vista clásica y luego puedes añadir el campo cuyo texto quieres mostar, el efecto puede ser parecido, pero no aparecera en valores si no en filas.

Otra opción puede ser indexar con valores unicos los conceptos que te interesa mostrar y vincular con un array y buscarv esos valores a el texto alq ue se asocian.

 

Espero poder ayudar

 

Saludos

JCH

@MasterBMN 

Creo que es esto lo que quieres conseguir, pero yo no iria por la via de los formatos personalizados de numeros.

 

Mira a ver si esta solución te ayuda

 

Saludos