Add a comma after the second digit of a cell.
Solved
Ltdvnk
Posted messages
2
Status
Member
-
eriiic Posted messages 24581 Registration date Status Contributor Last intervention -
eriiic Posted messages 24581 Registration date Status Contributor Last intervention -
Bonjour,
I am looking to automatically add a comma after the second digit of each cell.
Here is an excerpt from my database:
14452 18326 17005 19121 17927 18225 1821 18006
14834 18725 17363 19438 18263 18363 183 18017
14961 18675 17192 191 18109 18278 1809 17834
15409 1886 17309 1928 18236 18353 18172 17916
15128 18553 17037 18991 1794 18075 17897 1762
17458 21 18686 20485 19781 19156 18582 18118
Here is what I would like, including for whole numbers like the bold 21:
14,452 18,326 17,005 19,121 17,927 18,225 18,,21 18,006
14,834 18,725 17,363 19,438 18,263 18,363 18,3 18,017
14,961 18,675 17,192 19,1 18,109 18,278 18,09 17,834
15,409 18,86 17,309 19,28 18,236 18,353 18,172 17,916
15,128 18,553 17,037 18,991 17,94 18,075 17,897 17,62
17,458 21,00 18,686 20,485 19,781 19,156 18,582 18,118
Thank you in advance :)
I am looking to automatically add a comma after the second digit of each cell.
Here is an excerpt from my database:
14452 18326 17005 19121 17927 18225 1821 18006
14834 18725 17363 19438 18263 18363 183 18017
14961 18675 17192 191 18109 18278 1809 17834
15409 1886 17309 1928 18236 18353 18172 17916
15128 18553 17037 18991 1794 18075 17897 1762
17458 21 18686 20485 19781 19156 18582 18118
Here is what I would like, including for whole numbers like the bold 21:
14,452 18,326 17,005 19,121 17,927 18,225 18,,21 18,006
14,834 18,725 17,363 19,438 18,263 18,363 18,3 18,017
14,961 18,675 17,192 19,1 18,109 18,278 18,09 17,834
15,409 18,86 17,309 19,28 18,236 18,353 18,172 17,916
15,128 18,553 17,037 18,991 17,94 18,075 17,897 17,62
17,458 21,00 18,686 20,485 19,781 19,156 18,582 18,118
Thank you in advance :)
4 answers
-
Hello
When is this assignment due?
Best regards -
Hello,
Hi JCB,
hum, not sure this is an exercise, or else he's dealing with a perverse one and it's a punishment :-)=A2/10^(MID(TEXT(A2,"0.00E+00"),SEARCH("+",TEXT(A2,"0.00E+00"))+1,5)-1)
set the desired number format
eric
Edit: or in a less mathematical way:=--(LEFT(A2,2)"."& MID(A2,3,5))
By continuously trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, yes, it happens!!!), remember to mark it as resolved. Thanks -
Hello,
I don't know if my formula will work, but I'm giving it a try
First number in A1
=VALUE(LEFT(A1,2)","&RIGHT(A1,LEN(A1)-2))
set the desired format - copy the new table and paste it onto the old one using special paste V
Best regards -
Hello
if we believe the given example, all values are 5 digits
if this is confirmed, to keep it simple- enter 1000 in a cell outside the range
- copy it
- select the range to process
- right click / special paste / "division"
best regards
--
The quality of the answer mainly depends on the clarity of the question, thank you!
