Saturday, November 23, 2013

yogi_Replicate Numbers According To Specified Criteria (number of digits and leading 0s and without comma)

                                          Google Spreadsheet   Post  #1428
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 23, 2013
question by ergalthema (http://productforums.google.com/forum/?zx=e8vm8nb175an#!mydiscussions/docs/E6GnGfQrawk)
I can't have numbers beyond 999 without commas?
I tried to duplicate a cell with 9644 in it, and all the other cells say "9,644". I have tried changing the format to plain text, normal, and a few others - nothing has changed it.
Attachments (1)
Google Sheet Number Commas.PNG
2 KB   View   Download
---