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

decimal point appearing comma

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Decimal Point appearing as Comma

Decimal Point appearing as Comma

ResolvedVersion 2007

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?

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

RE: Decimal Point appearing as Comma

Thanks Anthony, Perfect! Thats it sorted!

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

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.1 secs.