Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Comma to decimal point
|
|
|
The UK's most regular 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. |
microsoft excel training - Comma to decimal point
Resolved · Low Priority · Version Standard
Reply Wed 22 Aug 2007, 16:47Delegate Tyrel said...
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?
For upcoming training course dates see: Pricing & availability
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
|