excel clear sets format as accounting
In a specific workbook when i use Clear > All or Clear > Formats Excel sets the number format to Accounting instead of General.
This does not happen in other workbooks. It seems that Excel is using Accounting format as the "normal" format for this workbook.
Does anyone know if it possible to set the "normal" format for a workbook in Excel?
microsoft-excel cell-format
asked Jan 22 at 12:41
flaiflai
12
add a comment |
In a specific workbook when i use Clear > All or Clear > Formats Excel sets the number format to Accounting instead of General.
This does not happen in other workbooks. It seems that Excel is using Accounting format as the "normal" format for this workbook.
Does anyone know if it possible to set the "normal" format for a workbook in Excel?
microsoft-excel cell-format
asked Jan 22 at 12:41
flaiflai
12
Welcome to SuperUser! This may have something to do with the original template the workbook was based on and may be related to this: stackoverflow.com/questions/44680465/…
– Rey Juna
Jan 22 at 18:11
add a comment |
In a specific workbook when i use Clear > All or Clear > Formats Excel sets the number format to Accounting instead of General.
This does not happen in other workbooks. It seems that Excel is using Accounting format as the "normal" format for this workbook.
Does anyone know if it possible to set the "normal" format for a workbook in Excel?
microsoft-excel cell-format
asked Jan 22 at 12:41
flaiflai
12
In a specific workbook when i use Clear > All or Clear > Formats Excel sets the number format to Accounting instead of General.
This does not happen in other workbooks. It seems that Excel is using Accounting format as the "normal" format for this workbook.
Does anyone know if it possible to set the "normal" format for a workbook in Excel?
microsoft-excel cell-format
microsoft-excel cell-format
asked Jan 22 at 12:41
flaiflai
12
asked Jan 22 at 12:41
flaiflai
12
asked Jan 22 at 12:41
flaiflai
12
asked Jan 22 at 12:41
flaiflai
12
asked Jan 22 at 12:41
flaiflai
12
12
Welcome to SuperUser! This may have something to do with the original template the workbook was based on and may be related to this: stackoverflow.com/questions/44680465/…
– Rey Juna
Jan 22 at 18:11
add a comment |
Welcome to SuperUser! This may have something to do with the original template the workbook was based on and may be related to this: stackoverflow.com/questions/44680465/…
– Rey Juna
Jan 22 at 18:11
Welcome to SuperUser! This may have something to do with the original template the workbook was based on and may be related to this: stackoverflow.com/questions/44680465/…
– Rey Juna
Jan 22 at 18:11
Welcome to SuperUser! This may have something to do with the original template the workbook was based on and may be related to this: stackoverflow.com/questions/44680465/…
– Rey Juna
Jan 22 at 18:11
add a comment |
1 Answer
1
active
oldest
votes
Excel uses the same principle of a normal style as Word does.
Hence to format the Normal style in Excel right click the style (in the Styles selection box) and click Modify ... then select Format ... and choose then in Number choose the format that best suits your needs.
Please see image bellow.
Picture: Excel Modify cell format
answered Jan 23 at 13:07
flaiflai
12
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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%2fsuperuser.com%2fquestions%2f1397004%2fexcel-clear-sets-format-as-accounting%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Excel uses the same principle of a normal style as Word does.
Hence to format the Normal style in Excel right click the style (in the Styles selection box) and click Modify ... then select Format ... and choose then in Number choose the format that best suits your needs.
Please see image bellow.
Picture: Excel Modify cell format
answered Jan 23 at 13:07
flaiflai
12
add a comment |
Excel uses the same principle of a normal style as Word does.
Hence to format the Normal style in Excel right click the style (in the Styles selection box) and click Modify ... then select Format ... and choose then in Number choose the format that best suits your needs.
Please see image bellow.
Picture: Excel Modify cell format
answered Jan 23 at 13:07
flaiflai
12
add a comment |
Excel uses the same principle of a normal style as Word does.
Hence to format the Normal style in Excel right click the style (in the Styles selection box) and click Modify ... then select Format ... and choose then in Number choose the format that best suits your needs.
Please see image bellow.
Picture: Excel Modify cell format
answered Jan 23 at 13:07
flaiflai
12
Excel uses the same principle of a normal style as Word does.
Hence to format the Normal style in Excel right click the style (in the Styles selection box) and click Modify ... then select Format ... and choose then in Number choose the format that best suits your needs.
Please see image bellow.
Picture: Excel Modify cell format
answered Jan 23 at 13:07
flaiflai
12
answered Jan 23 at 13:07
flaiflai
12
answered Jan 23 at 13:07
flaiflai
12
answered Jan 23 at 13:07
flaiflai
12
12
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1397004%2fexcel-clear-sets-format-as-accounting%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
Welcome to SuperUser! This may have something to do with the original template the workbook was based on and may be related to this: stackoverflow.com/questions/44680465/…
– Rey Juna
Jan 22 at 18:11