Dot and comma

G

Guest

Hello, i copied some values to my excel chart. But the numbers are like 2.3
and 5.9 etc. A dot has bee used instead of comma. Excel formats the cells as
date. How can i make it so that it would take those figures as they are -
numers?
Thank you
 
D

David Biddulph

Your easiest way is probably to adjust the Regional Settings in Windows
Control Panel. After you've imported your data you can put the settings
back as they were.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimal dot to Decimal Comma 3
csv format is wrong in Denmark 3
Decimal Points and comma separators 2
How to remove first comma in a value 8
Importing txt-file with "." (= dot) as decimal separator doesn't w 2
Switching dot for comma on dot key of keypad 6
test text string for a comma (,) 3
Comma as decimal separator 4

Top