Search This Blog

Search Engine

Custom Search

20090727

How to convert numbers into words in excel in Indian Rupees

Click on below link

http://in.geocities.com/shahshaileshs/

Then when web page comes click on "Indian Rupees"

You will be asked for downloading a zip file

Download it (on Desktop)

Later unzip the file.

The file will run and a button will be added to excel

Everytime you want to convert figures into words in terms of ruppees just click on this button

and all the figures will be converted into words in terms of rupees thereby saving time & energy




IN CASE ABOVE LINK NOT WORKING HERE IS ANOTHER LINK


http://knowpapa.com/num2words/


PASTE EITHER ENTIRE COLUMN OR 1 CELL HERE & THE WEBLINK WILL CONVERT ALL INTO WORDS

20090717

Toll free nos. for Home Appliances

1) Bru Coffee Vending Machines
1800 44 7171


2) Anchor Switches
1800 22 7979

3) DishTV
1800 12 3474

4) Blue Star
1800 22 2200

5) Godrej
1800 22 5511

20090712

If vlookup or any other = formula does not work in excel what to do?

If vlookup or any other = formula does not work in excel then what to do?



The = formula does not work in excel

  1. Select all = containing cells
  2. Then Go to "Data" (6 tabs away from File tab on horizontal axis)
  3. Go to "Text to Column"
  4. Go to "Delimited"
  5. Click "Next"
  6. Again Click "Next"
  7. Click "Finish"
  8. Then = formula will give value.

However same might not work for very backward & very very old version of Excel.
Is applicable for newer versions of excel perhaps from Excel 5.0 onwards.

20090710

How to view today's Insat-weather picture for India?

Today's insat picture of weather for India
Available on below link
Go to website - http://www.weather.nic.in/ (Now moved)
Click on Meteosat 5 (CIMSS)IR (Now moved)

UPDATE

Go to WEBSITE given below for viewing Present Day's Satellite view for India
http://imd.gov.in 
the IMD's website goes to the satellite link.

We will be getting today's or latest insat picture for India


This will help you to know how the rainfall is likely if you are going on a tour.
Can be also viewable from mobile. 
Just click http://imd.gov.in 



ADDITIONAL

INSAT IMAGES

All the timings on the images are in GMT.
To convert it to Indian Standard time you have to add
05 hrs 30 Minutes.


20090709

How to add prefix as 0 or many zeroes to a number?

ADD PREFIX TO A NUMBER IN EXCEL



  1. Type any number say 9999999
  2. Right click this cell containing this number
  3. Go to Format cells
  4. Click on Number Tab
  5. Click on General
  6. Then Go to Custom
  7. Below Type "General" wud be written
  8. Type it as 000000000
  9. On typing 9 zeroes we will be getting 009999999

20090703

Multiplex in Pune

City Pride - 24212355

E-Square - 66044141

Gold Adlabs - 66096565 & 66096464

INOX - 26050101

Mangala - 25533468

Fame - 27442744

City Pride Kothrud - 25458875

Telephone Services in Pune-Contact nos.

Fault Repair Service - 198

Directory Enquiry - 197

Local Number changes - 1951 & 1952 & 1953

- At these numbers revised landline nos. for Pune BSNL can be obtained

RTO offices in Pune Contact Nos.

PMC

Pune RTO - 26058080



PCMC

Chikhali RTO - 27492828

Municipal Services in Pune - Contact No.

General Enquiry & Complaints - 25501000



PMC

Street lights and faults - 25501371 & 70

Garbage/Refuse Removal - 25501403 & 05

Dead Animal Removal - 25501227 & 28

Drainage & Maintenance - 25501405 & 09

Road Maintenance - 25501217



PCMC

Dead Animal Removal - 27120407

Central Enq. Department - 27477777 - Extn. 4413

Railway Inquiry nos. in Pune

General - 131

Reservation - 132

Arrival & Departures (Recorded) - 133



Enquiry - 2612 6575

Computer Reservation - 2613 6666