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!
-------------------------------------------------------------------------------------------------------------------------------------------------
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!
-------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment