I've been working with inventory spreadsheets in Google Sheets. I have many SKU's in my inventory and when pasting or typing them in, they are interpreted as text and are left justified in general format cells. For example,
But when I type the SKU
LS-1001, it gets reinterpreted as -Ls 1000 or -Ls 1001, both of which are right aligned and appear to be interpreted as numbers representing
Re-entering the values in as
'LS-1000 forces it to be entered as text, but can anybody tell me what is going on here?