Leading Zeros causes rule error message

Programming and Web Development Forums - MS EXCEL - This section provides information about Excel commands and functions, Excel states, worksheet and expression evaluation, active vs. current worksheet, and worksheet references

Skip to content

Leading Zeros causes rule error message

MS EXCEL
Post a reply

    Next

  • 1. Reviewing Toolbar - how to stop it from displaying
    I have Excel 2003 and I'm noticing that the Reviewing toolbar pops up every time I open a workbook that I didn't create. Does anyone know how to turn this feature off. If and when I want it, I'll turn the reviewing toolbar on. I don't like it automatically poping up because it eats up some of my screen real estate. Thanks.
  • 2. 1 file = 2 versions
    I don't know what I did,but when I open one of my files, 2 versions open. One is testfile:1 and the other is testfile:2. How can I get rid of the :2 ? Thanks,
  • 3. Maskerr function not working on my new computer - help?
    I started a new job an have a new computer. I cannot get the "maskerr" function to work. Says I need to run a macro. Any ideas what might be wrong?

Leading Zeros causes rule error message

Postby TWF0dCBN » Tue, 25 Sep 2007 12:22:00 GMT 

I'm running Excel 2002 for a spreadsheet to keep track of access codes for a 
security system.  Some of the feilds start with a zero, so I have the cell 
formatted as text.  When I enter the number I'm getting a small green 
triangle in the upper left hand portion of the cell.  When I put my mouse 
over it, I get the message "the number in this cell is formatted as text or 
preceded by an apostrophe."  The only way i can keep the leading zeros is to 
ignore error.  I even get this message if I put any number in that does not 
start with zero.  Does anybody have any ideas on how I can correct this, as 
the entire sheet is almost affected by this.

Thanks!
Top

Re: Leading Zeros causes rule error message

Postby Tim Zych » Tue, 25 Sep 2007 12:45:12 GMT 

That can be disabled in the Options/Error checking tab. Either disable all 
error checking or just number stored as text.
Top

RE: Leading Zeros causes rule error message

Postby T3NzaWVNYWM » Tue, 25 Sep 2007 12:46:01 GMT 

Hi Matt,

Select Tools->Options->Error Checking Tab and then uncheck 'Number stored as 
text.'

Regards,

OssieMac
Top

Similar Threads:

1.Validation rule - custom 5 digits w/ leading zeroes 

I am having trouble creating a validation rule for cells.  I would like only 
6 digit numbers to be entered.  However, when using CUSTOM (000000) I can't 
seem to get it to work.  Any thoughts?

012345
234567

It works for 234567 but not for 012345

2.Replace leading zeros with leading spaces ? 

I am using Excel 2007.
Format (12,00 gives me 012
I want (12,?0 to be  12 with a leading space

Question mark doesn seem to work in Excel 2007

3."rule in error" message 

I keep getting told that I don't have permissions to apply my rules yet I am 
the only user on my home computer, so I am the admin.  What more do I need?

4."Rules in error" message when logging into Outlook 

I will get right to it. Outlook XP Pro. Service pack 2. 
No viruses no spyware. Running on a company network. 
Every time I open up Outlook I get this message "Rules in 
error"  - "Server requested client action"   - "Error -
movecopy, unable to create dest msg."

I had numerous rules running, I then removed all rules, 
installed Outlook on a different machine, but when I 
logged in again I get the same error message. This 
doesn't happen for another end user who logs into the 
machine under his profile. Heeeeelp. I am desperate!!

5.formating zip codes with leading zero to print zero 

I live in New England and our zip codes start with zero. When compiling a 
mailing list and then merging in Word, the zeros do not print. Is there a way 
to get these zeros to print without having to create a formula (which I have 
done). Also, I know that if you start with ' and then type your number the 
zero will print. I usually get a mailing list that someone has compiled and 
then I am stuck adding the ' to get the zeros to print. There must be an 
easier way!!!!!

6. zero supress leading zeros when chg format from text to number

7. zip code with leading zero ok in excel but mail merge has no zero

8. Zero values cause errors on log scale

Post a reply

Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 54 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group