Forum Discussion

Petulka's avatar
Petulka
Copper Contributor
Jan 10, 2021

text format green error triangle set-up issue

when importing a text file into excel, i do not get the text format green error triangle, which i could then click on and select "Convert to number", even though I have this specific error checking r...
excel
Petulka's avatar
Petulka
Copper Contributor
Jan 17, 2021

SergeiBaklan yes, this was selected. after contacting Microsoft support and several hours of tweaking, it turns out when you use shared files on 2 PC with different windows language, this feature doesn't work as intended due to the windows ignoring the regional settings of the file as such including this function, even if selected in options like you suggested.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 17, 2021

Petulka 

The key point is how do you share the file - is that network share; or homegroup share when file is located on one of PC; or OneDrive share with it's own language/regional settings.

  • Petulka's avatar
    Petulka
    Copper Contributor
    Jan 17, 2021

    SergeiBaklanunfortunately this is incorrect, we tried OneDrive, Dropbox and local copies, no difference, exact the same issue, until we changed the 2nd language windows to match the main one. This is a result of 2x4+ hours with Microsoft support including 2nd level support FYI

Resources