Prev: How do I count # of cells with same value other column?
Next: excel crashes when changing web query
From: MichelleT on 7 Apr 2010 23:48

From: Gord Dibben on 7 Apr 2010 23:58
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
special>multiply>esc

Delete cell with 100


Gord Dibben MS Excel MVP

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


 | 
Pages: 1
Prev: How do I count # of cells with same value other column?
Next: excel crashes when changing web query