Mixing
MS Excel custom formatting left to right
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
Need help regarding excel custom format, there used to be a symbol to format from left to right.
ex.
123456789 -> format 0-0-000 -> would be 12345-6-789
I'm looking for
123456789 -> format [unknown command]0-0-000 -> would be 1-2-3456789
I just can't find them.
Need them in custom format and not in VBA for the sake of frustration can't finding it. Thanks
excel
edited Jan 3 at 10:20
A.H.Nuri
815511
asked Jan 3 at 10:02
AlbertSanAlbertSan
216
add a comment |
Need help regarding excel custom format, there used to be a symbol to format from left to right.
ex.
123456789 -> format 0-0-000 -> would be 12345-6-789
I'm looking for
123456789 -> format [unknown command]0-0-000 -> would be 1-2-3456789
I just can't find them.
Need them in custom format and not in VBA for the sake of frustration can't finding it. Thanks
excel
edited Jan 3 at 10:20
A.H.Nuri
815511
asked Jan 3 at 10:02
AlbertSanAlbertSan
216
1
There is no such symbol, as far as I am aware.
– Rory
Jan 3 at 10:24
add a comment |
Need help regarding excel custom format, there used to be a symbol to format from left to right.
ex.
123456789 -> format 0-0-000 -> would be 12345-6-789
I'm looking for
123456789 -> format [unknown command]0-0-000 -> would be 1-2-3456789
I just can't find them.
Need them in custom format and not in VBA for the sake of frustration can't finding it. Thanks
excel
edited Jan 3 at 10:20
A.H.Nuri
815511
asked Jan 3 at 10:02
AlbertSanAlbertSan
216
Need help regarding excel custom format, there used to be a symbol to format from left to right.
ex.
123456789 -> format 0-0-000 -> would be 12345-6-789
I'm looking for
123456789 -> format [unknown command]0-0-000 -> would be 1-2-3456789
I just can't find them.
Need them in custom format and not in VBA for the sake of frustration can't finding it. Thanks
excel
excel
edited Jan 3 at 10:20
A.H.Nuri
815511
asked Jan 3 at 10:02
AlbertSanAlbertSan
216
edited Jan 3 at 10:20
A.H.Nuri
815511
asked Jan 3 at 10:02
AlbertSanAlbertSan
216
edited Jan 3 at 10:20
A.H.Nuri
815511
edited Jan 3 at 10:20
A.H.Nuri
815511
edited Jan 3 at 10:20
A.H.Nuri
815511
815511
asked Jan 3 at 10:02
AlbertSanAlbertSan
216
asked Jan 3 at 10:02
AlbertSanAlbertSan
216
asked Jan 3 at 10:02
AlbertSanAlbertSan
216
216
1
There is no such symbol, as far as I am aware.
– Rory
Jan 3 at 10:24
add a comment |
1
There is no such symbol, as far as I am aware.
– Rory
Jan 3 at 10:24
1
1
There is no such symbol, as far as I am aware.
– Rory
Jan 3 at 10:24
There is no such symbol, as far as I am aware.
– Rory
Jan 3 at 10:24
add a comment |
3 Answers
3
active
oldest
votes
This should work: #-#-#######
What is important is that the number of hash keys should correspond to the length of your number -> length of, or number of characters in, 123456789 is 9, the same as the number of hash keys above.
answered Jan 3 at 10:28
Ali NasserEddineAli NasserEddine
17816
add a comment |
You can use conditional formatting to achieve what you need.
- Select your data (let's say it's A1-A5)
- Open Conditional Formatting > New rule
- Select the last type "Use a formula to determine which cells to format"
- As a formula type
=LEN(A1)=5
- Open Format, select Custom and use
0-0-000
- Confirm everything
- Repeat steps 2-6 as long as you need changing formula to
=LEN(A1)=6,=LEN(A1)=7... and format to0-0-0000,0-0-00000...
answered Jan 3 at 10:53
Egan WolfEgan Wolf
3,0101823
add a comment |
0-0-0000000 is working for 9 digits numbers but for shorter like 12345 it will be 0-0-0012345
answered Jan 3 at 11:07
Ashraf FouadAshraf Fouad
34
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54020015%2fms-excel-custom-formatting-left-to-right%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
This should work: #-#-#######
What is important is that the number of hash keys should correspond to the length of your number -> length of, or number of characters in, 123456789 is 9, the same as the number of hash keys above.
answered Jan 3 at 10:28
Ali NasserEddineAli NasserEddine
17816
add a comment |
This should work: #-#-#######
What is important is that the number of hash keys should correspond to the length of your number -> length of, or number of characters in, 123456789 is 9, the same as the number of hash keys above.
answered Jan 3 at 10:28
Ali NasserEddineAli NasserEddine
17816
add a comment |
This should work: #-#-#######
What is important is that the number of hash keys should correspond to the length of your number -> length of, or number of characters in, 123456789 is 9, the same as the number of hash keys above.
answered Jan 3 at 10:28
Ali NasserEddineAli NasserEddine
17816
This should work: #-#-#######
What is important is that the number of hash keys should correspond to the length of your number -> length of, or number of characters in, 123456789 is 9, the same as the number of hash keys above.
answered Jan 3 at 10:28
Ali NasserEddineAli NasserEddine
17816
answered Jan 3 at 10:28
Ali NasserEddineAli NasserEddine
17816
answered Jan 3 at 10:28
Ali NasserEddineAli NasserEddine
17816
answered Jan 3 at 10:28
Ali NasserEddineAli NasserEddine
17816
17816
add a comment |
add a comment |
You can use conditional formatting to achieve what you need.
- Select your data (let's say it's A1-A5)
- Open Conditional Formatting > New rule
- Select the last type "Use a formula to determine which cells to format"
- As a formula type
=LEN(A1)=5
- Open Format, select Custom and use
0-0-000
- Confirm everything
- Repeat steps 2-6 as long as you need changing formula to
=LEN(A1)=6,=LEN(A1)=7... and format to0-0-0000,0-0-00000...
answered Jan 3 at 10:53
Egan WolfEgan Wolf
3,0101823
add a comment |
You can use conditional formatting to achieve what you need.
- Select your data (let's say it's A1-A5)
- Open Conditional Formatting > New rule
- Select the last type "Use a formula to determine which cells to format"
- As a formula type
=LEN(A1)=5
- Open Format, select Custom and use
0-0-000
- Confirm everything
- Repeat steps 2-6 as long as you need changing formula to
=LEN(A1)=6,=LEN(A1)=7... and format to0-0-0000,0-0-00000...
answered Jan 3 at 10:53
Egan WolfEgan Wolf
3,0101823
add a comment |
You can use conditional formatting to achieve what you need.
- Select your data (let's say it's A1-A5)
- Open Conditional Formatting > New rule
- Select the last type "Use a formula to determine which cells to format"
- As a formula type
=LEN(A1)=5
- Open Format, select Custom and use
0-0-000
- Confirm everything
- Repeat steps 2-6 as long as you need changing formula to
=LEN(A1)=6,=LEN(A1)=7... and format to0-0-0000,0-0-00000...
answered Jan 3 at 10:53
Egan WolfEgan Wolf
3,0101823
You can use conditional formatting to achieve what you need.
- Select your data (let's say it's A1-A5)
- Open Conditional Formatting > New rule
- Select the last type "Use a formula to determine which cells to format"
- As a formula type
=LEN(A1)=5
- Open Format, select Custom and use
0-0-000
- Confirm everything
- Repeat steps 2-6 as long as you need changing formula to
=LEN(A1)=6,=LEN(A1)=7... and format to0-0-0000,0-0-00000...
answered Jan 3 at 10:53
Egan WolfEgan Wolf
3,0101823
answered Jan 3 at 10:53
Egan WolfEgan Wolf
3,0101823
answered Jan 3 at 10:53
Egan WolfEgan Wolf
3,0101823
answered Jan 3 at 10:53
Egan WolfEgan Wolf
3,0101823
3,0101823
add a comment |
add a comment |
0-0-0000000 is working for 9 digits numbers but for shorter like 12345 it will be 0-0-0012345
answered Jan 3 at 11:07
Ashraf FouadAshraf Fouad
34
add a comment |
0-0-0000000 is working for 9 digits numbers but for shorter like 12345 it will be 0-0-0012345
answered Jan 3 at 11:07
Ashraf FouadAshraf Fouad
34
add a comment |
0-0-0000000 is working for 9 digits numbers but for shorter like 12345 it will be 0-0-0012345
answered Jan 3 at 11:07
Ashraf FouadAshraf Fouad
34
0-0-0000000 is working for 9 digits numbers but for shorter like 12345 it will be 0-0-0012345
answered Jan 3 at 11:07
Ashraf FouadAshraf Fouad
34
answered Jan 3 at 11:07
Ashraf FouadAshraf Fouad
34
answered Jan 3 at 11:07
Ashraf FouadAshraf Fouad
34
answered Jan 3 at 11:07
Ashraf FouadAshraf Fouad
34
34
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54020015%2fms-excel-custom-formatting-left-to-right%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
There is no such symbol, as far as I am aware.
– Rory
Jan 3 at 10:24