News Update :
Home » » Put zeros before a number while keeping the possibility of calculating

Put zeros before a number while keeping the possibility of calculating

By: omer nawaz on Sunday, 3 November 2013 | 23:10

Very useful to align the numbers in a cell
the walk-through: use the custom formatting
 
Procedure
  • selecting the cell or cells
  • Format dropdown menu
  • cell line
  • In the window that opens many tab should be selected by default
  • place the dropdown
  • and at the end select the option "Custom
  • and in the box type as zero indicate that we want numbers
  • and confirm with OK

  • verify that you have

Post a Comment

 
Contact Us | Privacy policy | Term of use | Advertise with Us | Site map
Copyright © 2011. Blogging Brain . All Rights Reserved.
Design Template by Blogging Brain | | Powered by Blogger