gerard1234
New Member
- Joined
- Oct 11, 2018
- Messages
- 5
I want to automatically delete the thousand separator in this value. Can someone pls. help me with a Excel formula?
1.500.00
1.500.00
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Delete thousand separator
Rick Rothstein
MrExcel MVP
- Joined
- Apr 18, 2011
- Messages
- 38,522
- Office Version
- 365
- Platform
- Windows
Peter's formula works for me as well. Here is an alternate formula that you can also try...
=TEXT(SUBSTITUTE(A2,".",""),"0\.00")
Perhaps your experience with it might help us narrow down why you are having a problem. If you do still have a problem, tell us about it in detail (see what Peter posted in Message #6 for the kind of details we would need to know)
=TEXT(SUBSTITUTE(A2,".",""),"0\.00")
Perhaps your experience with it might help us narrow down why you are having a problem. If you do still have a problem, tell us about it in detail (see what Peter posted in Message #6 for the kind of details we would need to know)
Upvote
0
Excel Facts
What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
