picklefactory
Well-known Member
- Joined
- Jan 28, 2005
- Messages
- 506
- Office Version
- 365
- Platform
- Windows
Hi folks
Not sure if I'm just being dumb here. (Probably), but......I have simple column of dates, I have set format to dd/mm/yy. Am I correct in thinking this should force dates entered into this format? Reason I ask is that I'm trying to create a sheet to make people keep to the correct syntax. But even with cells formatted as above, I can still enter 04.07.08 or 04.07/08 or 04/07.08 or 04.07.2008 and other variants and they remain as typed. Shouldn't the formatting sort this out and fix the syntax to the format I selected?
Thanks
Not sure if I'm just being dumb here. (Probably), but......I have simple column of dates, I have set format to dd/mm/yy. Am I correct in thinking this should force dates entered into this format? Reason I ask is that I'm trying to create a sheet to make people keep to the correct syntax. But even with cells formatted as above, I can still enter 04.07.08 or 04.07/08 or 04/07.08 or 04.07.2008 and other variants and they remain as typed. Shouldn't the formatting sort this out and fix the syntax to the format I selected?
Thanks