View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Formula to scan group of four cells?

Hi Terry,

Am Fri, 06 Sep 2019 16:28:14 +0100 schrieb Terry Pinnell:

You entered my '0.6' as '0,6'. I assume you have Excel Options Advanced Decimal
separator set that way, the German standard?

Both now do exactly what I need, thanks so much ;-)


in Germany the decimal separator is a comma. But when the numbers are
correct formatted this comma will in your system change tu period.


Regards
Claus B.
--
Windows10
Office 2016