Excel Comma Not Working In Formula

Due to OS setting some time comma (,) not working in Excel formula, Two way to solve this problem.


1
  • Using Excel Function Argument - Go to formula Tab - Insert Function/Click on Fx left of  formula bar - Choose any one function - GO


2
  • Using Control Panel - Windows 7 - Control Panel - Regional Setting - Additional Settings - List Separator - Change another into Comma (,) - Apply and OK.



  • Windows 10 - Control Panel - Clock Language and Regon - Region Change date or number formates - Additional Settings - Numbers - List Separator - Change another into Comma (,) - Apply and OK



No comments:

Post a Comment