Excel tips......

-


In excel if we are try to add more numbers (1234567891011123)
 may be it will show just like this

       1.23457E+11



How we can clear it ,,

first select the column, 
then options - format cells-




then select the -text- , then ok ...


Then double click the column, you can see it as you type...'


Enjoy.......
  

Comments

Post a Comment

Popular posts from this blog

-
Image
HOW TO IMPORT CONTACTS TO NOKIA BASIC PHONE LIKE NOKIA 150 While we are using NOKIA basic phone like NOKIA 150 we may face problem that  there no option for import contacts. How to copy contacts? We need four things : 1- Nokia 150 with SD card 2- VCF file  3- USB cable 4- Computer Steps: 1- Backup your contacts from your device (Iphone, Android, nokia, also from gmail, icloud) to VCF file ( contacts.vcf ). 2- Change the file name and extension ( contacts.vcf ) to ( backup.dat ). 3- Connect your Nokia to a computer with a USB, you will get two choices on the Nokia screen (Charging only and Mass storage), choose Mass Storage ,  don't press  done . 4- You will get a new  Removable Disk in my computer , then copy the renamed file( backup.dat ) to your SD card. 5- Back to your phone ,  press Done and disconnect the USB. 6- On the Nokia go to  Menu –> Settings –> Backup –> Restore backup,    you...
Read more

How to activate staple option in RISO COMCOLOR 7150 ShareEmbedEmail

-
Image
How to activate staple option in  RISO COMCOLOR 7150  I am using RISO COMCOLOR 7150 . when i am trying to print there is no staple option in printer setting. How to Fix? > open printer properties (start menu- device and printers - you can find you printer) > Go to "SECURITY" tab there allow all the permissions  > go to next tab "environment"    then click on "Get printer info" If you insert the staple in printer there you can see offset stapler as "installed" then apply and ok now you can get staple option in printer setting check my video  Thanks  Team Let us share
Read more

How to export contacts from Icloud

-
Image
How to export contacts from Icloud 1 -  Open Icloud in you PC and sign in . (May be you need verify your account if you activate Two factor Authentication)  2 - In the left bottom corner you can see setting icon . click on it and select export vCard. 3- your contact will be downloaded soon  . you can copy it to SD card and also can restore to your sim card. Thanks  Team Let us share....
Read more