Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
cajundoc
 
Posts: n/a
Default How do I start an Excel entry with then number 0?

How do I start an Excel cell entry with the number 0? (i.e. a pin number or
zip code). Every time I enter it, then move out of the cell, the computer
automatically removes the 0 in front of the remaining numbers.
  #2   Report Post  
Marvin P. Winterbottom
 
Posts: n/a
Default

format the cells text to begin with, or put a single quote ' in front of the
zero
  #3   Report Post  
N Harkawat
 
Posts: n/a
Default

before entering data go to Format-Cells-Text
This will now allow you to enter the data with 0 prefixed to a number
OR
Enter ' before your number

"cajundoc" wrote in message
...
How do I start an Excel cell entry with the number 0? (i.e. a pin number
or
zip code). Every time I enter it, then move out of the cell, the computer
automatically removes the 0 in front of the remaining numbers.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Where is DateDiff function in Excel 2002 ? Nigel Welch Excel Worksheet Functions 4 March 4th 05 03:18 PM
In Excel how can a number automatically display in text form Curtis A Excel Worksheet Functions 2 February 26th 05 11:31 AM
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 08:13 PM
How do I set up a field in an Excel form to number it incremental. max Excel Worksheet Functions 1 November 29th 04 10:33 PM


All times are GMT +1. The time now is 11:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"