Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft excel training - comma decimal point

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Comma to decimal point

microsoft excel training - Comma to decimal point

ResolvedVersion Standard

Tyrel has attended:
Excel Advanced course

Comma to decimal point

How do you change info that has a decimal point to show "thousand" and a comma to show the decimals ie convert financial info from German format to UK format?

RE: comma to decimal point

Hi Tyrel,

If the cell is in text format, you may need to write a macro to convert all commas to decimal points and vice-versa.

If the cells/data are in number format, see below...

In Excel, go to Tools -> Options -> International tab. Under the 'Number handling' heading, check the decimal and thousands separator. If you untick the box below this ('use system separators'), you'll be able to edit the two boxes with the separator of your choice.

You may need to format the cell to be Number + Use 1000's separator + 2 decimal places.

Another reason may be your system may be set up with locale information for Germany (or any other country using Euros), which would mean your thousands seperator is a . and your decimal point is a comma. eg. 2.999,95

To check this in Windows, go to Start -> Settings -> Control Panel -> Regional and Language Options -> and ensure the correct country is selected.

Hope this helps. Thanks again for attending our Excel Advanced course.

Regards, Rich

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.