Thread: Dot and comma
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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