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   Nov 23, 2013
question by ergalthema (!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