Stop automatically changing numbers to dates-Microsoft Excel

Stop automatically changing numbers to dates

Microsoft Excel is preprogrammed to make it easier to enter dates. For example, 12/2 changes to 2-Dec. This is very frustrating when you enter something that you don't want changed to a date. Unfortunately there is no way to turn this off. But there are ways to get around it.
Preformat the cells you want to enter numbers into as Text. This way Excel will not try to change what you enter into dates.

1. Select the cells that you’ll enter numbers into.
2. Press Ctrl + 1 (the 1 in the row of numbers above the QWERTY keys) to open Format Cells.
3. Select Text, and then click OK.

If you only have a few numbers to enter, you can stop Excel from changing them into dates by entering:

• A space before you enter a number. The space remains in the cell after you press Enter. (See Notes)
  
• An apostrophe (‘) before you enter a number, such as ’11-53 or ‘1/47. The apostrophe isn’t displayed in the cell after you press Enter.
  
• A zero and a space before you enter a fraction such as 1/2 or 3/4 so that they don’t change to 2-Jan or 4-Mar, for example. Type 0 1/2 or 0 3/4. The zero doesn’t remain in the cell after you press Enter, and the cell becomes the Fraction number type.
  
  Notes: 

  • We recommend using an apostrophe instead of a space for entering data if you plan on using lookup functions against the data. Functions like MATCH or VLOOKUP overlook the apostrophe when calculating the results.
    
  • If a number is left-aligned in a cell that usually means it isn’t formatted as a number.
    
  • If you type a number with an “e” in it, such as 1e9, it will automatically result in a scientific number: 1.00E+09. If you don’t want a scientific number, enter an apostrophe before the number: ‘1e9
    
  • Depending on the number entered, you may see a small green triangle in the upper left corner of the cell, indicating that a number is stored as text, which to Excel is an error. Either ignore the triangle, or click on it. A box will appear to the left. Click the box, and then select Ignore Error, which will make the triangle go away.

CanoScan LiDE 110 on Ubuntu 14.04

https://alioth.debian.org/frs/?group_id=30186

LiDE 210/110 scanner working under Ubuntu 10.10 you need to:

 $ sudo add-apt-repository ppa:plaxx/random-fixes
$ sudo apt-get update
$ sudo apt-get install libsane sane-utils

Version 1.025-git fixed it for me.
See: https://bugs.launchpad.net/~rolfbensch/+archive/ubuntu/sane-git/+index?field.series_filter=utopic
and do this:

sudo add-apt-repository ppa:rolfbensch/sane-git
sudo apt-get update
sudo apt-get upgrade

https://alioth.debian.org/frs/?group_id=30186

http://www.sane-project.org/lists/sane-mfgs-cvs.html#Z-CANON 

A SOFTWARE FOR SCANNER


https://www.hamrick.com/download.html

Canon LBP2900 working in Ubuntu 14.04

1. Download Linux capt driver version 2.71
   
   
2. Extract it into download folder and opened the folder for 32 bit, as my installation is 32 bit:
   downloads → linux capt... → 32 bit driver → debian
   
   
3. After that double click on the files, the Ubuntu software center opens and asks to install it. Install both the files one by one, second one first.
4. Install the following additional packages from the Ubuntu software center: portreserve, gsfonts, gsfonts-other, gsfonts-X11.
   
   
5. Restart the printer
   

   service cups restart
   

6. Add your printer
   
   
   
   7...start the printer daemon:
   

   sudo /usr/sbin/lpadmin -p LBP2900 -m CNCUPSLBP2900CAPTK.ppd -v ccp://localhost:59787 -E 
   sudo /usr/sbin/ccpdadmin -p LBP2900 -o /dev/usb/lp0
   sudo service ccpd start
   sudo service ccpd status

7. Check the function of the printer:
   

   captstatusui -P LBP2900

   this will popup a new window.  

    8....If the message is error of no printer connected etc., restart
    the PRINTER 

   9...If the message is "Ready to print", you are done.
   
   10...If the message is again error of no printer connected etc., restart the operating system and repeat the steps five to seven, and it will start.

Sometimes it may stop working after restart, then run

sudo service ccpd restart 

https://askubuntu.com/questions/487627/how-to-install-canon-lbp2900b-printer-in-14-04-lts-i-tried-the-method-for-lbp2

HOW CHANGE BOOT PRIORITY BETWEEN LINUX AND WINDOWS

HOW CHANGE BOOT PRIORITY BETWEEN LINUX AND WINDOWS 
 
Application--->System Tools--->Administration-->Grub Customizer

WIFI ON DELL 1810 Qualcomm Atheros Device 0042 (rev 31)

 

 

 2 Answers

	You should just need firmware that Ubuntu has included in the latest linux-firmware version. Install with  Press Ctrl+Alt+T wget http://mirrors.kernel.org/ubuntu/pool/main/l/linux-firmware/linux-firmware_1.158_all.deb sudo dpkg -i linux-firmware_1.158_all.deb Reboot

Try this: Internet connected your ethernet card. Open a terminal, Press Ctrl+Alt+T Run it: exec sudo -i apt-get update apt-get install build-essential linux-headers-$(uname -r) git echo "options ath10k_core skip_otp=y" | tee /etc/modprobe.d/ath10k_core.conf wget https://www.kernel.org/pub/linux/kernel/projects/backports/2015/11/20/backports-20151120.tar.gz tar zxvf backports-20151120.tar.gz cd backports-20151120 make defconfig-wifi make make install git clone https://github.com/kvalo/ath10k-firmware.git cp -r ath10k-firmware/QCA9377 /lib/firmware/ath10k/ cp /lib/firmware/ath10k/QCA9377/hw1.0/firmware-5.bin_WLAN.TF.1.0-00267-1 /lib/firmware/ath10k/QCA9377/hw1.0/firmware-5.bin reboot     Whenever you upgrade your kernel you must run exec sudo -i cd backports-20151120 make clean make defconfig-wifi make make install

How to Install the Gnome Classic Desktop in Ubuntu 14.04

In Ubuntu 14.04, you cannot change the window control buttons to the right side of the title bar anymore. If you prefer the window control buttons on the right, or you just don’t like Unity, you can easily go back to the classic Gnome desktop.
NOTE: When we say to type something in this article and there are quotes around the text, DO NOT type the quotes, unless we specify otherwise.

To install the Gnome desktop, press Ctrl + Alt + T to open a Terminal window. Type the following line at the prompt and press Enter. The line is actually two commands. The first command (before the semicolon) updates Ubuntu and the second installs the Gnome desktop.

sudo apt-get update; sudo apt-get install gnome-session-fallback

Type your password when prompted and press Enter.

The progress of the installation displays and then a message displays saying how much disk space will be used. When asked if you want to continue, type a “y” and press Enter.

When the installation is finished, close the Terminal window by typing “exit” at the prompt and pressing Enter.

Click on the system menu in the upper-right corner of the screen and select Log Out to log out of your session.

On the login screen, click the Ubuntu icon.

A list of available desktop environments display. Select the GNOME Flashback option for either Compiz or Metacity.

You are automatically returned to the login screen. Enter your password and press Enter to log in.

The classic Gnome desktop displays with the standard Gnome menus in the upper-left corner of the screen.

TP LINK WIRELESS ADAPTOR ---UBUNTU

TP LINK WIRELESS ADAPTOR ---UBUNTU

http://www.tp-link.com/en/download/TL-WN823N_V2.html#Driver

 To compile and install the proprietary Realtek 8192cu driver, run the following commands in an open terminal:

sudo apt-get update && sudo apt-get install git build-essential linux-headers-generic dkms
git clone https://github.com/dz0ny/rt8192cu.git --depth 1
cd rt8192cu
sudo make dkms

https://askubuntu.com/questions/246236/compile-and-install-rtl8192cu-driver

restart the computer


1. Development Environment
System version: Ubuntu 14.04.1
Kernel version: 3.16.0-30-generic
Gcc version:4.8.2

2. Compile the Driver
2.1. Compilation tool and kernel sources
Before you compile the driver, please make sure you have the correct compile tool and
kernel sources.
We can install compile tool gcc by command “apt-get install gcc”
Note : We recommend you use a suitable compile tool to compile our driver.
For example:

According to the command “sudo cat /proc/version”, we could see your linux system is compiled

by gcc4.8.2. So we recommend you use gcc4.8.2 to compile our driver if possible.
2.2. Compile and install the Driver

1. Access the directory of driver.

2. Before compile, make sure the parameters in “makefile.c” is suitable for your
compile environment of your Linux system.


ifeq ($(CONFIG_PLATFORM_I386_PC), y)
EXTRA_CFLAGS += -DCONFIG_LITTLE_ENDIAN
SUBARCH := $(shell uname -m | sed -e s/i.86/i386/)
ARCH ?= $(SUBARCH)
CROSS_COMPILE ?=
KVER := $(shell uname -r)
KSRC := /lib/modules/$(KVER)/build
MODDESTDIR := /lib/modules/$(KVER)/kernel/drivers/net/wireless/
INSTALL_PREFIX :=
endif



Explanation:
· KSRC is used to specify the kernel source path for driver compilation.
· CROSS_COMPILE is used to specify the toolchain.
· ARCH is used to specify the target platform's CPU architectures such as arm, mips,
i386 and so on.
1If your Linux kernel does not support 802.11, please annotate macro

“CONFIG_IOCTL_CFG80211” in “makefile.c”.
CONFIG_IOCTL_CFG80211=n
ifeq ($(strip &(CONFIG_IOCTL_CFG80211)),y)
EXTRA_CFLAGS + = -DCONFIG_IOCTL_CFG80211 = 1
EXTRA_CFLAGS + = -DRTW_USE_CFG80211_STA_EVENT = 1
endif

3. Type “sudo make” to compile the driver file.

4. Type “sudo make install” to install the driver file.

JIOFI

JIOFI

 Access the URL http://jiofi.local.html or http://192.168.225.1 using a web browser. This will take you the page where you can manage the JioFi’s settings.

 Now login with the credentials, username as administrator and password as administrator and tap on the login button. You might be prompted to change the default administrator password. You can do this by clicking on OK.