Formulas 1

[sofiavba]

Can anyone tell me if it is possible to have two different types of formats on one cell? For example if I enter 100%, do a percent formula and if I enter 100 I do an integer value formula.

 

[SkipVought]

Hi,

You are not referring to FORMULAE, but rather to FORMATTING.

Once you enter a value as a percent ie 75%, Excel expects that every other value that you enter will be a percent.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[firefytr]

As SkipVought points out, Excel tries to be intuitive. It will retain the format of the first cell it "senses" which needs an applied format. To combat this, I generally recommend the keyboard shortcuts.

Ctrl + Shift + ~ = General
Ctrl + Shift + 1 = Number
Ctrl + Shift + 2 = Time
Ctrl + Shift + 3 = Date
Ctrl + Shift + 4 = Currency
Ctrl + Shift + 5 = Percent
Ctrl + Shift + 6 = Exponent

So I would just hit Ctrl + Shift + ~ or 1 to return to General/Number format.

HTH

-----------
Regards,
Zack Barresse

 

[SkipVought]

Learn sumthin' new every day!

Thanx Zack ==> *

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[xlbo]

you could do it via the change event in code but it seems to me it would be more hassle than its worth.

On a seperate note, I cannot think of a good reason to have different number types in the same cell....I would recommend not doing so to be honest as it infers to me that there is a fundamental issue with the spreadsheet design

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

Ditto Geoff!

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}