If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Number Format

Thread starter lakshmipathi123
Start date Aug 18, 2015
Tags

number format

lakshmipathi123

Board Regular

Aug 18, 2015

How convert/show number format from 8.123,00 to 8,123.00 in Excel 2010.

Excel Facts

Select all contiguous cells

Click here to reveal answer

Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Sort by date Sort by votes

ismii

Board Regular

Aug 18, 2015

Could be system format.

Excel Menu > Excel Options > Advanced > Editing Options >

Uncheck "Use system separators"
Change the separators you would like to use.