number input

's Computer Specifications

Wht is it that Excel does not accept a zero as the first number of a 5 digit
zip code? How do you get Excel to accept it?

's Computer Specifications

Type a leading apostrophe before the leading zero.......this will set the
cell as TEXT format.

Vaya con Dios,
Chuck, CABGx3

"dennisp" wrote:

> Wht is it that Excel does not accept a zero as the first number of a 5 digit
> zip code? How do you get Excel to accept it?

's Computer Specifications

If you want the numbers to be treated as numbers not text,
format the cell first to have custom format of 00000

On Thu, 03 Aug 2006 17:10:02 +0100, dennisp
<(E-Mail Removed)> wrote:

> Wht is it that Excel does not accept a zero as the first number of a 5
> digit
> zip code? How do you get Excel to accept it?

--
Steve (3)

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I input number in Access data type=number; format=percent	Help Visio!	Microsoft Access Getting Started	5	26th Aug 2008 09:12 PM
Input mask date syntax-limit input to a number range	=?Utf-8?B?QmlsbGlhbQ==?=	Microsoft Access Database Table Design	2	18th Nov 2007 04:37 PM
input in number form is being multiplied by 1000 when i input.	=?Utf-8?B?andlaW5vZ3JhZA==?=	Microsoft Excel Misc	4	17th Apr 2007 12:18 AM
making a cell fixed number to a input number	fwday	Microsoft Excel Programming	1	25th Oct 2003 03:38 AM
making a cell fixed number to a input number	fwday	Microsoft Excel Misc	9	22nd Oct 2003 04:48 AM