Format american numbers into normal numbers swap dots & comma

Resolved · Low Priority · Version 2010

Tue 10 Sep 2013, 11:56 Delegate Maria said...

Maria has attended:
Excel Intermediate course

Format american numbers into normal numbers swap dots & comma

Is there a quicker way to format american number ( quicker than one below)

1.235,25 into normal 1,235.25

You can do a find and replace all to manage it.

1) find the dot and replace all with nothing
2) find the comma and replace all with the dot

Be aware that it will find all commas and dots in other areas of the page you are working on.

Please suggest

Tue 10 Sep 2013, 15:01 Trainer Gary said...

RE: format american numbers into normal numbers swap dots & c

Hi Maria

Thanks for getting in touch. To fix this depends on a few settings. First click on a cell that contains the problem numbers. Then right-click and choose Format Cells.

On the Number tab, what option is selected? If it's Custom, what is in the Type box?

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 17 Sep 2013: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Missing Field handle

If your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked.

View all Excel hints and tips