Keeping a fixed constant (like letter “M”) and a variable (like a number “100”) in the same cell in...

up vote
1
down vote

favorite

In excel, is there a method where a constant term can be fixed in the cell and I only need to input the variable term.
(this is difficult to put in words)

example:

So, I have different values, like 100M, 50M, 30M, 40M, etc.

Now, can I keep the "M" fixed so that I only need to input the numerical value?
Like I just type "100" but it shows "100M"?

Is it also possible to have a formula that ignores the "M"?

Like, A1=100M, B1=30M. Now, I want C1=A1-B1 to be "70M" instead of "#value!"?

Is this possible to do if I can keep the "M" as a fixed value instead of manually inputting it?

asked 21 hours ago

user28219

353125

add a comment |

up vote
1
down vote

favorite

In excel, is there a method where a constant term can be fixed in the cell and I only need to input the variable term.
(this is difficult to put in words)

example:

So, I have different values, like 100M, 50M, 30M, 40M, etc.

Now, can I keep the "M" fixed so that I only need to input the numerical value?
Like I just type "100" but it shows "100M"?

Is it also possible to have a formula that ignores the "M"?

Like, A1=100M, B1=30M. Now, I want C1=A1-B1 to be "70M" instead of "#value!"?

Is this possible to do if I can keep the "M" as a fixed value instead of manually inputting it?

asked 21 hours ago

user28219

353125

add a comment |

up vote
1
down vote

favorite

In excel, is there a method where a constant term can be fixed in the cell and I only need to input the variable term.
(this is difficult to put in words)

example:

So, I have different values, like 100M, 50M, 30M, 40M, etc.

Now, can I keep the "M" fixed so that I only need to input the numerical value?
Like I just type "100" but it shows "100M"?

Is it also possible to have a formula that ignores the "M"?

Like, A1=100M, B1=30M. Now, I want C1=A1-B1 to be "70M" instead of "#value!"?

Is this possible to do if I can keep the "M" as a fixed value instead of manually inputting it?

asked 21 hours ago

user28219

353125

In excel, is there a method where a constant term can be fixed in the cell and I only need to input the variable term.
(this is difficult to put in words)

example:

So, I have different values, like 100M, 50M, 30M, 40M, etc.

Now, can I keep the "M" fixed so that I only need to input the numerical value?
Like I just type "100" but it shows "100M"?

Is it also possible to have a formula that ignores the "M"?

Like, A1=100M, B1=30M. Now, I want C1=A1-B1 to be "70M" instead of "#value!"?

Is this possible to do if I can keep the "M" as a fixed value instead of manually inputting it?

microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2007

asked 21 hours ago

user28219

353125

asked 21 hours ago

user28219

353125

asked 21 hours ago

user28219

353125

asked 21 hours ago

user28219

353125

asked 21 hours ago

user28219

353125

add a comment |

1 Answer
1

active

oldest

votes

up vote
2
down vote

select all the cell you need.. r-click > format cell > custom : #,##0.00 [$M]

done.

If you don't need the comma separator or decimal.. just put 0 [$M] will do. If without the space between the number and 'M' .. then use 0[$M]

hope it helps. ( :

p/s: Idea source = setting the 'M' as a currency character.

answered 21 hours ago

p._phidot_

47328

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',
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
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1374945%2fkeeping-a-fixed-constant-like-letter-m-and-a-variable-like-a-number-100%23new-answer', 'question_page');
}
);

Post as a guest

Name

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
2
down vote

select all the cell you need.. r-click > format cell > custom : #,##0.00 [$M]

done.

If you don't need the comma separator or decimal.. just put 0 [$M] will do. If without the space between the number and 'M' .. then use 0[$M]

hope it helps. ( :

p/s: Idea source = setting the 'M' as a currency character.

answered 21 hours ago

p._phidot_

47328

add a comment |

up vote
2
down vote

select all the cell you need.. r-click > format cell > custom : #,##0.00 [$M]

done.

If you don't need the comma separator or decimal.. just put 0 [$M] will do. If without the space between the number and 'M' .. then use 0[$M]

hope it helps. ( :

p/s: Idea source = setting the 'M' as a currency character.

answered 21 hours ago

p._phidot_

47328

add a comment |

up vote
2
down vote

select all the cell you need.. r-click > format cell > custom : #,##0.00 [$M]

done.

If you don't need the comma separator or decimal.. just put 0 [$M] will do. If without the space between the number and 'M' .. then use 0[$M]

hope it helps. ( :

p/s: Idea source = setting the 'M' as a currency character.

answered 21 hours ago

p._phidot_

47328

select all the cell you need.. r-click > format cell > custom : #,##0.00 [$M]

done.

If you don't need the comma separator or decimal.. just put 0 [$M] will do. If without the space between the number and 'M' .. then use 0[$M]

hope it helps. ( :

p/s: Idea source = setting the 'M' as a currency character.

answered 21 hours ago

p._phidot_

47328

answered 21 hours ago

p._phidot_

47328

answered 21 hours ago

p._phidot_

47328

answered 21 hours ago

p._phidot_

47328

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Name

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Gfrktyl