G
Gord Dibben
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
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