SOLVED

formule not showing completly at formula bar

Copper Contributor

i had a windows 8 after that i upgrade it to windows 10 and reinstalling the microsoft 2019 to be competeble with windows 10 . now my forumles working but not showing completly in formula bar

i tried to open same file in another computer and it works good without any problem 

 

excel 1.jpg

 

5 Replies

@dirani94 just expand the formula bar down

Use the down arrow on the right hand side

 

bhushan_z_0-1591768257419.png

 

And it will expand like this:

bhushan_z_2-1591768306914.png

 

 

 

@bhushan_z  thanks for your fast replay

Unfortunately this is not the problem, I am including a picture to describe the problem clearly

Ahhh, this is strange.
Sorry, have not seen this before
best response confirmed by dirani94 (Copper Contributor)
Solution

 @dirani94 i could solve the problem 

the cause was i changed the list separator symbol from (,) to (\t)
i returned it to (,) and now its working well

steps :
control panel >> region >> additional settings >> separator symbol

excel 2.jpg

thanks you again
i solved the problem you can see it in the replays
1 best response

Accepted Solutions
best response confirmed by dirani94 (Copper Contributor)
Solution

 @dirani94 i could solve the problem 

the cause was i changed the list separator symbol from (,) to (\t)
i returned it to (,) and now its working well

steps :
control panel >> region >> additional settings >> separator symbol

excel 2.jpg

View solution in original post