Amit at Digital Inspiration features a lengthy way of creating beautiful excel cell art from an image. I guess we all can use a method that is little simpler and smarter.
The objective: to convert an image to cell art by adjusting background color
The Means: obviously VBA
The Solution: Of course someone already solved it, and it is none other than Andy Pope. Download the tool for converting BMP files to XY Scatter charts or cell art from his site. Once you have the file,
- Take any image you want to convert and open it in an image editor like Paint.NET or photoshop
- Reduce the number of colors in the image to 56
- Save the image as BMP
- Now go back to the downloaded file and open the VB Editor (Alt+F11)
- Open the form frmBMPLoader and hit F5 to run the form
- Specify the BMP file path to convert the image to cell art
- Once the processing is done, adjust zoom (to 10%) to see the entire image
What next? Now that you know a cool way to have some fun with excel, why not get serious and read some of the past posts on PHD 😛 ?
4 Responses to “Using Credit Card Numbers in Excel”
Parsing so that it can do 16 digits is great. Now, add in extra script to validate the digits (check that the first number is a 4 or 5 - Visa vs Mastercard, 6 for Discover). 🙂
I put the validation in another box, and point it towards the cell with the card data.
=IF(LEFT(D3,1)="4","Visa",IF(LEFT(D3,1)="5","Mastercard", IF(LEFT(D3, 1)="6", "Discover")))
[…] http://chandoo.org/wp/2009/04/07/using-credit-card-numbers-in-excel/ […]
Sir
i want A1 cell input Pan No. so only First 5 text and mid 4 numberand last one text only enter
otherwise envaild