Skip to main content
Web Applications

Return to Question

added 11 characters in body; edited title
Source Link
pnuts
pnuts
  • 17.8k
  • 5
  • 54
  • 103

What is "-Ls 10001000" in Google sheetsSheets?

I've been working with inventory spreadsheets in Google sheetsSheets.

  I have many SKU's in my inventory and when pasting or typing them in, thethey are interpreted as text and are left justified in general format cells.

  For example, CF-55BCF-55B, BB-32BB-32, JR-3039JR-3039.

But when I type the SKU LS-1000LS-1000 or LS-1001LS-1001, it gets reinterpreted as -Ls 1000 or -Ls 1001, both of which are right aligned and appear to be interpreted as numbers representing -1000-1000 and -1001-1001.

Re-entering the values in as 'LS-1000'LS-1000 forces it to be entered as text, but can anybody tell me what is going on here?

What is -Ls 1000 in Google sheets

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, the are interpreted as text and are left justified in general format cells.

  For example, CF-55B, BB-32, JR-3039.

But when I type the SKU LS-1000 or 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 -1000 and -1001.

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?

What is "-Ls 1000" in Google Sheets?

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, CF-55B, BB-32, JR-3039.

But when I type the SKU LS-1000 or 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 -1000 and -1001.

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?

Tweeted twitter.com/#!/StackWebApps/status/528370793109942272
Source Link
Fauxcuss
Fauxcuss
  • 233
  • 1
  • 3
  • 10

What is -Ls 1000 in Google sheets

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, the are interpreted as text and are left justified in general format cells.

For example, CF-55B, BB-32, JR-3039.

But when I type the SKU LS-1000 or 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 -1000 and -1001.

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?