How do I apply the general number format "0.00" to the selection using
shortcut keys?

Can't find it via the help feature.

Thanks.

Epinn

Hi Eppin,

There is the 'increase decimal' and 'decrease decimal'
buttons on the formatting Toolbar.

HTH
Martin

CTRL-1 is the shortcut for format cells, but you would still have to
click the Number tab and click OK for 2 decimal places. General format
does not only apply to numbers.

Hope this helps.

Pete

Epinn wrote:
> How do I apply the general number format "0.00" to the selection using
> shortcut keys?
>
> Can't find it via the help feature.
>
> Thanks.
>
> Epinn

Thank you both for your response. I guess I wasn't too clear.

I am hoping to find the shortcut to change 12345 to 123.45 and not to
12345.00.

I want something similar to ctrl+shift+# changing the date 8/10/06 to
dd-mmm(Aug)-yy.

If I have a whole bunch of cells that I need to set the format, I know I can
go to tools>options>edit>fixed decimal places and set it to 2. I am
thinking of changing one or two cells casually.

Your suggestions are well taken.

Epinn

"Pete_UK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> CTRL-1 is the shortcut for format cells, but you would still have to
> click the Number tab and click OK for 2 decimal places. General format
> does not only apply to numbers.
>
> Hope this helps.
>
> Pete
>
> Epinn wrote:
> > How do I apply the general number format "0.00" to the selection using
> > shortcut keys?
> >
> > Can't find it via the help feature.
> >
> > Thanks.
> >
> > Epinn
>

ctrl+shift+# puts it back to generla dopwsn't it ?

anyway you actuall want to change the data, ie from 12345 to 123.45

you'll have to divide all by 100, then format to 2 dec places

dividing by 100 is easy
put 100 in a temp cell
copy this, select the celss you want to divide by 100
paste special, select divide

Steve

On Thu, 10 Aug 2006 17:11:56 +0100, Epinn <(E-Mail Removed)_SPAM>
wrote:

> Thank you both for your response. I guess I wasn't too clear.
>
> I am hoping to find the shortcut to change 12345 to 123.45 and not to
> 12345.00.
>
> I want something similar to ctrl+shift+# changing the date 8/10/06 to
> dd-mmm(Aug)-yy.
>
> If I have a whole bunch of cells that I need to set the format, I knowI
> can
> go to tools>options>edit>fixed decimal places and set it to 2. I am
> thinking of changing one or two cells casually.
>
> Your suggestions are well taken.
>
> Epinn
>
> "Pete_UK" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> CTRL-1 is the shortcut for format cells, but you would still have to
>> click the Number tab and click OK for 2 decimal places. General format
>> does not only apply to numbers.
>>
>> Hope this helps.
>>
>> Pete
>>
>> Epinn wrote:
>> > How do I apply the general number format "0.00" to the selection using
>> > shortcut keys?
>> >
>> > Can't find it via the help feature.
>> >
>> > Thanks.
>> >
>> > Epinn
>>
>
>



--
Steve (3)

I know of no shortcut key method for this.

You can add this macro and give it a shortcut key.

Sub divide()
Dim cel As Range
For Each cel In Selection
cel.Value = cel.Value / 100
Next cel
End Sub


Gord Dibben MS Excel MVP

On Thu, 10 Aug 2006 12:11:56 -0400, "Epinn" <(E-Mail Removed)_SPAM> wrote:

>Thank you both for your response. I guess I wasn't too clear.
>
>I am hoping to find the shortcut to change 12345 to 123.45 and not to
>12345.00.
>
>I want something similar to ctrl+shift+# changing the date 8/10/06 to
>dd-mmm(Aug)-yy.
>
>If I have a whole bunch of cells that I need to set the format, I know I can
>go to tools>options>edit>fixed decimal places and set it to 2. I am
>thinking of changing one or two cells casually.
>
>Your suggestions are well taken.
>
>Epinn
>
>"Pete_UK" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> CTRL-1 is the shortcut for format cells, but you would still have to
>> click the Number tab and click OK for 2 decimal places. General format
>> does not only apply to numbers.
>>
>> Hope this helps.
>>
>> Pete
>>
>> Epinn wrote:
>> > How do I apply the general number format "0.00" to the selection using
>> > shortcut keys?
>> >
>> > Can't find it via the help feature.
>> >
>> > Thanks.
>> >
>> > Epinn
>>
>

Well accountants seem able to use
Tools, Options, Edit, Fixed decimal: 2
most of us happen upon this option, think it didn't do anything
and then find a couple of days later that all entered numbers are
wrong. And then turn off the option and are very careful not to use
it again. I would go for the macro applied selectively already
supplied.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Epinn" <(E-Mail Removed)_SPAM> wrotel...
> Thank you both for your response. I guess I wasn't too clear.
>
> I am hoping to find the shortcut to change 12345 to 123.45 and not to
> 12345.00.