98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · Low Priority · Version 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Rotating Text in an Excel 2010 WorksheetMaybe you want to draw attention to certain text or you just simply want to make your worksheet look more exciting! |