Tuesday, January 29, 2013

yogi_Show Numeric Entries In Column A Into Column B With + - Sign And Leave Text Entries As Is


                                          Google Spreadsheet  Post  #994

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 29, 2013
user Paul Curtis said:(http://productforums.google.com/forum/?zx=605ui8ts3fnb#!category-topic/docs/spreadsheets/wT8HWdxuN1o)
Positive numbers + sign 
Is there a way in Google Spreadsheets to format a positive number e.g. +4 instead of 4
----------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem where I have also considered negative numbers as well as TEXT entries