Log In
Register
Home
What I need it: 6177164 to be 61,77164 in the neighboring column.
I use this formula: =LEFT(A2,2)&","&RIGHT(A2,LEN(A2)-2)
When I tried to execute this formula now, I get an error window.
There's a problem with this formula. Not trying to type a formula?
When the first charcter is an equal(=) or minus (-) sign, Excel thinks it's a formula.
you type: =1=1, cell shows : 2
To get around this, type an apostrphe (') firts:
you type: '=1=1, cell shows: =1+1
Anybody know why this just started or how tosolve it? Any help would be greatly appreciated.
July 16, 2010
Offline
I can't replicate this issue. When I enter that formula it returns 61,77164
Trusted Members
Moderators
January 31, 2022
Offline
I suspect that your system uses the semi.-colon as the list separator.
Try =LEFT(A2;2)&","&RIGHT(A2;LEN(A2)-2)
Of course, you are aware that this creates a text. In case you intend to output a number with 5 decimals you could try this:
= A2 / 100000
1 Guest(s)
