HI... Is it possible???

sergio.exsa

New Member
Joined
Jul 27, 2006
Messages
14
Is there a way to prevent or stop excel from changing the format of a cell when a user input data on it.... ill explain:

in cell A1 i have a format of text, but if a user write a date the format of the cell changes to date... how can i lock the format of that cell...


Thanks for your comments....
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi Segio

Are you sure you have it formatted as text? I can't recreate what you are seeing (ie date stays as text).
 

Watch MrExcel Video

Forum statistics

Threads
1,114,042
Messages
5,545,688
Members
410,698
Latest member
Wloven
Top