Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dot and comma
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dot and comma
Highlight your range
EditReplace Find What: . Replace with , Click Replace All "raigo" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dot and comma
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. -- David Biddulph "raigo" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|