Guest
Guest
Guests
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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: David Benady, Dom Brosnahan, Robert Primmer
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Michal Kučera
Stephen Keating
David M Connelly
Quick Analytics
Peter Craven
Thomas Huybs
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Forum Stats:
Groups: 3
Forums: 24
Topics: 6881
Posts: 30160
Member Stats:
Guest Posters: 49
Members: 33708
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —