Saturday, October 26, 2013

yogi_Sort Source Data By Column A So That Sorted Data Has Year Numbers Without Comma

                                          Google Spreadsheet   Post  #1399
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct 26, 2013
question by Curdflappers (http://productforums.google.com/forum/?zx=902onk148d1f#!category-topic/docs/spreadsheets/eL52sfD09HM)
How to format years as numbers, but without commas
I want to organize a sheet chronologically, and I have all the years in one column. I can get them formatted as numbers, but this makes them look funny. The year '1963' looks like '1,963' and I don't like it. If I format the numbers as regular text, the comma goes away, but I can't sort chronologically! Any help would be greatly appreciated!
-------------------------------------------------------------------------------------------------------------------------------------------------