What are the shortcut keys for "0.00"

[Epinn]

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

 

[MartinW]

Hi Eppin,

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

HTH
Martin

 

[Pete_UK]

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]

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

 

[SteveW]

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

 

[Gord Dibben]

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

 

[David McRitchie]

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.