How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 31121
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

How to convert comma to dot for data?

This answer was rated:

How to convert comma to dot for data?
Thank you for your question, my name is Richard.

Can you tell me what program you are referring to please?

Thank you

Customer: replied 3 years ago.

Excel 2010

Thanks Jan.

Click anywhere in the column with the dates.

Press ALT+F in Excel, then click Replace.

Click options to set it to look in the column

enter , in find and . in replace,

Allow it to replace all, and it will convert the , to a .

If you have any difficulties at all, please do not hesitate to let me know so I can assist you further

Thank you
Customer: replied 3 years ago.

How to convert comma to dot? Both comma and dot shall mean a decimal.


 


Example: 3,41 ==>3.41 How to be able to do that in Excel 2010.























case 1:
write 3,41
==>3,41
case 2:
write 3.41 ==>15036,00

Best regards Jan.

Thanks Jan

Its your computer causing this, not Excel.

Click Start, Control Panel

Open Regional and Language Options

Click Change the Date, Time or Number Format.

Click the Addition Settings Button

Then change the decimal to a . from ,

Then click ok to save

Restart Excel and is will pick up the settings.

If you have any difficulties at all, please do not hesitate to let me know so I can assist you further

Thank you



Richard and other Microsoft Office Specialists are ready to help you
Customer: replied 3 years ago.


You did find out. Very good.


Thanks a lot!


 


best regards


Jan from Norway.

Thank you Jan!

All the best.

Richie

Related Microsoft Office Questions