When you open CSV document using Microsoft Excel, if you have a column with numeric data and leading 0, Excel will automatically delete the 0 and convert it the field type to number. To avoid Excel doing this automatically, there are several ways. For me, the easiest way is by importing the CSV file instead of opening it straight in Excel. To do that, follow the steps below Open a blank Microsoft Excel document. Navigate to data tab on your toolbar. Click import data from text. Find your csv file and click import. Leave the default choices - file type as delimited, start import at row 1, and file origin: MS-DOS and press Next. On the next screen, tick comma under delimiter options. You can untick or leave tab as it is. Press next. On the last screen, change the column with leading zero numeric data format as text. To do this, simply click on the column and change the column data format as Text. Click finish.It will ask where do you want to put the data, press Ok.
Showing posts from July, 2014
- Other Apps
By Flickr -
To make sure you win ever time you race on dragon track, follow the guide below: * Pay attention on the track name . For example on the picture below, the track name is Rime or Reason. * Select dragon based on this guide below: Blast Furnace - Fire, metal (Forge Dragon, Brass Dragon, Sulfur Dragon) Cherry Road - Fire, plant, earth (Cotton Dragon, Sakura Dragon, Carnival Dragon, Paper Dragon) Dramoria - Cold, metal (Mine Dragon, Steel Dragon, Bearded Dragon) Electric skies - Lightning, air (Sonic Dragon, Thunder Dragon, Butterfly Dragon, Liberty Dragon) Marsh Land - Plant, water, earth (Seaweed Dragon, Swamp Dragon, Bouquet Dragon) Shimmering Fault Line - Lightning, earth (Crystal Dragon, Quake Dragon, Cotton Dragon) Rime or Reason - Air, cold (Blizzard Dragon, Snow Dragon) Ulster Meadow - Earth, plant (Moss Dragon, Tree Dragon, Forest Dragon, Clover Dragon, Cotton Dragon, Mistletoe Dragon, Paper Dragon, Sakura Dragon, Carnival Dragon, Arbor Dragon) Year of