From: MichelleT on

From: Gord Dibben on
You cannot format that number in the manner you ask.

Multiply the cell by 100 to get your wish.

Enter 100 in an empty cell.

Copy that cell then select the cells with numbers and paste

Delete cell with 100

Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 20:48:01 -0700, MichelleT
<MichelleT(a)> wrote: