ExcelBanter - how do I change number format from 3,999.89 to 399989

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I change number format from 3,999.89 to 399989 (https://www.excelbanter.com/excel-worksheet-functions/260965-how-do-i-change-number-format-3-999-89-399989-a.html)

MichelleT

how do I change number format from 3,999.89 to 399989

Gord Dibben

how do I change number format from 3,999.89 to 399989

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
specialmultiplyesc

Delete cell with 100

Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 20:48:01 -0700, MichelleT
wrote:

All times are GMT +1. The time now is 01:47 PM.