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?

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


"Dieter" wrote in message
...
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?

"Bernie Deitrick" wrote:

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


"Dieter" wrote in message
...
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?

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

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,

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

Happy new year to you, too.

Bernie