98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Decimal Point appearing as Comma
Decimal Point appearing as Comma
Resolved · High Priority · Version 2007
Fri 19 Mar 2010, 19:22Delegate Kieran said...
Kieran has attended:
No courses
Decimal Point appearing as Comma
I have recently noticed that whenever I try to enter a .(decimal point) into a cell by using the .(decimal point) key on the Number pad, that it actually appears as a , (comma).
I've tried to change this, but my keyboard settings are set as UK, and it only happens with excel.
How can i get my decimal point to show a decimal point again?
Mon 22 Mar 2010, 10:47Trainer Anthony said...
RE: Decimal Point appearing as Comma
Hi Kieran, thanks for your query. Go to your Office button & Excel Options. In the Advanced category look in the first section Editing Options. At the bottom of that group look for Use System Separators and check they are set correctly.
Hope this helps,
Anthony
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:Random NumbersType =RAND()*200 to generate a number between 1 and 200. |
