zero or not ?

[Damntheman30]

Hi,

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

 

[deciog]

In cell formatting, in the Custom option, put this way 0000

Decio

 

[Fluff13]

Also posted

zero or not ?

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

www.mrexcel.com

 

[vletm]

Damntheman30
As a new user, You have just read Forum Rules ... yes
Please reread those from here: https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/
... especially part between How to get the Best Results at Chandoo.org and Always.
Please.