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
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 toolsoptionseditfixed 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" wrote in message
ups.com...
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)