Use the spreadsheet functions appear random numbers you can show a positive sign

Users questions: Used in the spreadsheet numbers appear random function can be shown how a positive sign, for example: +2, +3, -3
Experts answer:-1000 +1000 the following formula: = TEXT (RAND () * (1000 +1000) -1000 , "+0; -0")
  • This information provided by the users.Thanks!