View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How to convert comma to dot

Click the Office icon (colourful circle to the left on Ribbon)
Click Excel Options (bottom of Office dialog)
Click Advanced in the left side of Options dialog
Look at last item in the "Editing Options" group; this is where you set the
thousands and decimal separators
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Olinia" wrote in message
...
I am using Excel 2007. Sorry for stupid question, where is Tool. It was so
obvious for me with Exxel 2003, uh.

"Sean Timmons" wrote:

Assuming you want to change the decimal separator? If so, go to Tools -
Options - International tab, Uncheck Use System separators and change!

"Olinia" wrote:

How to convert comma to dot for data?