Truncate A Date to First of the Month

Writing by shivdev on Friday, 2 of November , 2007 at 2:33 pm

Want to convert 1/20/2007 to 1/1/2007 in Excel?
Use the DATE excel function.

=DATE(YEAR(A1),MONTH(A1),1)

Leave a comment

Category: Excel

Rotate Text in Excel

Writing by shivdev on Sunday, 28 of October , 2007 at 8:07 pm

Example of rotated textLooking to fit a bunch of columns on a page or improve readability of text in Excel by changing the alignment/orientation of the text? Then here are some steps.

  • Select the Cell(s) you want to change alignment for
  • Right Click and select Format Cells…
  • Select the Alignment Tab
  • Change the orientation by entering a degrees or dragging the orientation scale
  • Hit OK

Leave a comment

Category: Excel

Shivdev Kalambi's Blog

Shivdev Kalambi is a Principal Software Engineer working at ArcSight. He has over 11 years' experience in software development and has worked with several technologies and played different roles and contributed to all phases of projects. Other non-tech activies include Ping-pong, Racquetball, Rock Climbing at PG and Swimming.