Worksheet from Germany

D

Dieter

I have a large worksheet from Germany. All numbers are ##,## format and do
not work with formulas. I need to change the format to ##.## in order to work
with my formula. How can I do that?
 
B

Bernie Deitrick

Dieter,

You could try Tools / Options / International tab, and UNCheck "Use system separators" and then put
, as the decimal separator. Try setting that before opening the workbook.

If that doesn't work, try selecting all the cells and using Search/Replace - replacing , with .
Then you may also need to format the cells as number, and multiply the resulting values by 1 to get
them to be treated as numbers.

HTH,
Bernie
MS Excel MVP
 
D

Dieter

Bernie Deitrick said:
Dieter,

You could try Tools / Options / International tab, and UNCheck "Use system separators" and then put
, as the decimal separator. Try setting that before opening the workbook.

If that doesn't work, try selecting all the cells and using Search/Replace - replacing , with .
Then you may also need to format the cells as number, and multiply the resulting values by 1 to get
them to be treated as numbers.

HTH,
Bernie
MS Excel MVP




The surch replace worked very well for me thank you for getting me on the right track. Have a great day and a happy ne year. Dieter
Click to expand...
 
B

Bernie Deitrick

The surch replace worked very well for me thank you for getting me on the right track. Have a great
day and a happy ne year.
Click to expand...

Dieter,

Thanks for letting me know that you figured out your problem.

Happy new year to you, too.

Bernie
 
Top