formato porcentaje %

%3CLINGO-SUB%20id%3D%22lingo-sub-2672072%22%20slang%3D%22es-ES%22%3E%25%20percent%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672072%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%20everyone%20my%20conuslta%20is%20when%20in%20a%20list%20of%20cant%20and%20percentage%20the%20latter%20exceeds%20100%25%20even%20reaches%2013845%25%20I%20can%20think%20of%20showing%20instead%20number%20of%20times%20138.5x%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewould%20there%20be%20any%20other%20options%20in%20the%20formats%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2672072%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2672289%22%20slang%3D%22en-US%22%3ERe%3A%20formato%20porcentaje%20%25%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672289%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1134078%22%20target%3D%22_blank%22%3E%40Claudio_gabriel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20custom%20number%20format%20can%20test%20the%20value%20in%20order%20to%20use%20a%20different%20format%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23800080%22%3E%3CSTRONG%3E%5B%26lt%3B%3D1%5D0.00%25%3B0.00x%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3EConditional%20formatting%20will%20also%20allow%20different%20number%20formats%20to%20be%20selected.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hola a todos mi conuslta es cuando en una lista de cant y porcentaje  este ultimo supera el 100% inclusive llega a 13845%  se me ocurre mostrar en vez cantidad de veces 138,5x .

 

habría alguna otra opcion en los formatos?

1 Reply

@Claudio_gabriel 

A custom number format can test the value in order to use a different format

[<=1]0.00%;0.00x

Conditional formatting will also allow different number formats to be selected.