Skip to main content

Excel: Entering leading zeroes

Excel is often used as a database to hold information and not necessarily calculate numbers. One example is a mailing list. On campus, you only need to include the four-digit extension for the postal code. My mailing address would look like this:
Ranelle Maltas
104 ARCH
CC 0104

Here it is in Excel:

But how did I get the leading zero to stay? Usually when you type a number, such as 0104, it is formatted as a number, becomes right-aligned and drops the zero. You can format the cell as text instead, but that doesn't always help. What you need to do is type an apostrophe (') first. Don't worry, it will disappear like the image above. Here it is again in edit mode:








Share

Share in Google Buzz Buzz it

Facebook

Facebook Recommendations

Followers


Web Designing In Karachi



Haroof.com


Politics blogs

My Zimbio

Email Subscribe

Enter your email address:

Watch online Live TV

Popular posts from this blog

Matric General Group Result SECONDARY SCHOOL CERTIFICATE (S. S. C.) PART - II CLASS - X - 2010 (www.apnieyesp.com )

PASSED THE SECONDARY SCHOOL CERTIFICATE (S. S. C.) PART - II CLASS - X) ANNUAL EXAMINATION, 2010. ERRORS AND OMISSIONS EXCEPTED, CANDIDATES BEARING THE FOLLOWING ROLL NUMBERS ARE DECLARED TO HAVE PASSED THE SECONDARY SCHOOL CERTIFICATE (S. S. C.) PART - II CLASS - X) ANNUAL EXAMINATION, 2010. ------------------------------------------------- GENERAL GROUP (REG&PVT) --- GRADE..'A-ONE' ---- ----------------------- ( CANDIDATES SECURING TOTAL MARKS 680 AND ABOVE) MARKS SECURED BY THE CANDIDATES OUT OF TOTAL MARKS OF 850 ARE MENTIONED AGAINST EACH ROLL NUMBER IN BRACKET --------------------------------------------------- 601086 (689) XXX (XXX) XXX (XXX) XXX (XXX) XXX (XXX) XXX (XXX) 601327 (681) 363 (684) 364 (719) 407 (685) 664 (682) 788 (687) 601836 (692) 882 (683) XXX (XXX) XXX (XXX) XXX (XXX) XXX (XXX) 602315 (723) 316 (715) 320 (712) 321 (739) 325 (686) 326 (702) 602327 (683) 329 (70...

In Depth: Could robots be the writers of the future?

CNETAnalysis: It might be concerned with aliens, outer space and dimensional jumping for now, but ‘sci-fi’ might have to be redefined if the latest advances in automated writing continue apace. Software that can construct sentences, analyse data and even put a ‘spin’ on a news story are threatening to make the newsdesk and the author’s writing room very different places. The end for journalists? Journalism isn’t complicated. The popularity of online news stories can be tracked – and therefore the importance of news easily ranked – while almost everything is written using the inverted pyramid structure . Since automated writing software can already do most of that, are we looking at the last generation of human journalists? Narrative Science’s Quill is the leading automated writing software title. It transforms structured data into readable, plain English stories that are identical to those written by humans, ...

Cnews Latest Stories:

SC dismisses last petition against Musharraf’s eligibility ISLAMABAD: Supreme Court Thursday dismissed the last petition against President Musharraf's eligibility to contest the presidential elections. The verdict came after a brief hearing of Dr. Zahoor Mehdi’s petition by the full bench of the apex court headed by Chief Justice Mr. Justice Abdul Hameed Doggar.On Monday, the court had dismissed five petitions against President Musharraf’s nomination, including the challenges from the presidential candidate Justice (Rtd) Wajihuddin and Makhdoom Amin Fahim.Attorney General had earlier said that President Musharraf would quit his army post and take oath as civilian president as early as Saturday if the presidential re-election was approved by the apex court. Lahore: People pouring in camp to show solidarity with Geo (Updated at 1410) LAHORE: People from different walks of life continuously visiting the solidarity camp outside Geo office in Lahore to express solidarity with Geo Tele...

Labels

Show more