What are the shortcut keys for "0.00"

  • Thread starter Thread starter Epinn
  • Start date Start date
E

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
 
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
 
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
 
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
 
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
 
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.
 
Back
Top