zero or not ?

[Damntheman30]

Hi,
I need to write function that check: if the number I put in the cell start with 0 it will change the cell attribute to text otherwise the cell attribute will stay general
10x

 

[juddaaaa]

You'd be better changing the number format of the cell.

For example "0000" will pad every number so it's 4 digits long (so 1 will become 0001, 10 will be 0010 and so on)

 

[Damntheman30]

You'd be better changing the number format of the cell.

For example "0000" will pad every number so it's 4 digits long (so 1 will become 0001, 10 will be 0010 and so on)

i didn't explain my self as I want to.
like you wrote I need to change the cell format but I want the excel will do it automaticly. for example:
1234 ---> cell format will be general
01234 ---> cell format will be text
because i need the "0" in the begining

 

[Fluff]

Crossposted zero or not ?

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Rick Rothstein]

I want the excel will do it automaticly. for example:
1234 ---> cell format will be general
01234 ---> cell format will be text

As far as I know, Excel cannot do this. When you edit a cell, no VBA code can run until edit mode has been exited and Conditional Formatting only takes hold after the value has been entered. If the cell is formatted as General, Excel will treat all digits as a number and lop off leading zeros. You have two options... change all the cells in your range of interest to Text before entering data into them (personally, I do not see why you would want a mixture of real numbers and text numbers anyway) or type an apostrophe (') and then follow it with your leading zero number (the apostrophe tells Excel to treat the value as Text even if it is all digits).