SOLVED
Home

da 111.111,00 a 111,11

%3CLINGO-SUB%20id%3D%22lingo-sub-540303%22%20slang%3D%22en-US%22%3Eda%20111.111%2C00%20a%20111%2C11%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-540303%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3ECiao%20a%20tutti%2C%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3Edevo%20trasformare%20un%20numero%20111.111%2C00%20in%20111.111.%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3D%20se%20(a1%20%3D%20%23%23%23.%20%23%23%23%20%2F%201000%3B%20%22%22)%2C%20non%20funziona.%20%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3EMi%20d%C3%A0%20%22%23VALORE!%22%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3Ecome%20faccio%20a%20dire%20centinaia%20di%20migliaia%3F%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3EGrazie%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-540303%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-549673%22%20slang%3D%22en-US%22%3ERe%3A%20da%20111.111%2C00%20a%20111%2C11%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-549673%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F328743%22%20target%3D%22_blank%22%3E%40tradam_a%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECiao!%20(Resposta%20em%20Portugues%2FIngles)%3C%2FP%3E%3CP%3EO%20que%20quer%20fazer%3F%3C%2FP%3E%3CP%3E1%20-%20Ter%20o%20numero%20escrito%20na%20celula%20como%20TEXTO%20nesse%20formato%3F%20ou%3C%2FP%3E%3CP%3E2%20-%20Ter%20o%20numero%20escrito%20na%20celula%20como%20valor%20111111%2C%20mas%20exibido%20nesse%20formato%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPara%20opcao%202%3A%3C%2FP%3E%3CP%3Eselecciona%20a%20celula%2C%3C%2FP%3E%3CP%3Ehome%20tab%20%26gt%3B%20number%20%26gt%3B%20Custom%20%26gt%3B%20%23%23%23.%23%23%23%3C%2FP%3E%3CP%3E(na%20minha%20imagem%20tenho%20vigula%20em%20vez%20de%20ponto%20porque%20o%20meu%20sitema%20numerico%20e'%20o%20americano)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112629iAD935303CD4FFD0A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22tradam1.JPG%22%20title%3D%22tradam1.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESe%20for%20a%20opcao%201%20que%20necessita%2C%20poderemos%20usar%20uma%20formula%2C%20mas%20preciso%20de%20saber%20se%20o%20numero%20a%20que%20vai%20aplicar%20a%20formula%20tem%20sempre%206%20digitos.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBoa%20sorte!%20%3B-)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
tradam_a
Occasional Contributor

Ciao a tutti,

devo trasformare un numero 111.111,00 in 111.111.

= se (a1 = ###. ### / 1000; ""), non funziona. Mi dà "#VALORE!"

come faccio a dire centinaia di migliaia?

Grazie

1 Reply
Solution

@tradam_a 

Ciao! (Resposta em Portugues/Ingles)

O que quer fazer?

1 - Ter o numero escrito na celula como TEXTO nesse formato? ou

2 - Ter o numero escrito na celula como valor 111111, mas exibido nesse formato?

 

Para opcao 2:

selecciona a celula,

home tab > number > Custom > ###.###

(na minha imagem tenho vigula em vez de ponto porque o meu sitema numerico e' o americano)

tradam1.JPG

Se for a opcao 1 que necessita, poderemos usar uma formula, mas preciso de saber se o numero a que vai aplicar a formula tem sempre 6 digitos.

 

Boa sorte! ;-) 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies