RadhaKrishnaKiJaya
asked on
Set default text format
Hi Experts,
Is there a way to set the default format of few cells of worksheet to Text ot Number or Date? So that whenever it should stay there permanent and I would not have to chage it at all?
Thank you in Advance.
Is there a way to set the default format of few cells of worksheet to Text ot Number or Date? So that whenever it should stay there permanent and I would not have to chage it at all?
Thank you in Advance.
Hi,
Are you referring to in a saved worksheet that you utilize or overall in excel when you make a new workbook those cells are always that format?
If you're just talking about working within a specific worksheet right click the cell, go to format cells, and select the format you'd like it to default to under Categories:) if that's not what you meant just let me know, take care!
Are you referring to in a saved worksheet that you utilize or overall in excel when you make a new workbook those cells are always that format?
If you're just talking about working within a specific worksheet right click the cell, go to format cells, and select the format you'd like it to default to under Categories:) if that's not what you meant just let me know, take care!
ASKER
Thank you LifeN-Ti and tapanpattanaik for your help.
tapanpattanaik, your links are very informative. Thank you again.
LifeN-Ti, I am trying to make changes on a existing worksheet (saved worksheet). Yes, we can make changes by right click --> Format Cells etc. Here user can modify it. Here what I am looking for is to make the cell permanent. Even if user tries to modify, it should not work. In other words, to make the chages permanent.
Can we code it in ThisWorkBook (hit Alt + F11 key, you would see it), so that it should maintain the default format permanently? Please let me know. Thank you.
tapanpattanaik, your links are very informative. Thank you again.
LifeN-Ti, I am trying to make changes on a existing worksheet (saved worksheet). Yes, we can make changes by right click --> Format Cells etc. Here user can modify it. Here what I am looking for is to make the cell permanent. Even if user tries to modify, it should not work. In other words, to make the chages permanent.
Can we code it in ThisWorkBook (hit Alt + F11 key, you would see it), so that it should maintain the default format permanently? Please let me know. Thank you.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you LifeN-Ti, this is really helpful. I tried your instructions which protects the whole worksheet. Infact, I don't want to protect the worksheet altogether as the users need to update it frequently. Instead, I just want protects the format of the cells. For example, A1 can accept only numbers, nothing else. A2 can accepts only Dates, nothing else. Here, user can enter data, but not change the data type. I know we can achieve it using simple VBA coding inside ThisWorkBook. But I don't know how. Please let me know if you have any idea. Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi, are your worksheet formatting and data validation needs solved?
ASKER
Hi PortletPaul, Thank you for the post. They are very helpful. I did some temporary fix manually. Here I was looking for some kind of global macro, which should do it automatically. For example, the worksheet can read ThisWorkBook file upon activating the macro (hit Alt + F11 key). Thank you.
ASKER
Thank you guys for your help.
Please check these links.
Setting Up Excel Default Formatting:
http://www.pchelpsblog.com/2011/03/productivity-101-setting-up-excel-default-formatting/
http://www.meadinkent.co.uk/xlconfigure.htm