dates...

  • Thread starter Thread starter carla
  • Start date Start date
C

carla

i was wondering if there was a way to format a whole
column to return a date format no matter which way a
person was to eneter a date. for example, wheni used the
format function, the only way it will change it to my pick
is when its entered dec 12, 2003. if its entered
12/12/2003, it will stay like that? ugh
any ideas?
thanks so much if anyone can help :)
 
Try changing the format of the cell to text instead of a
date. The downfall is that using text will allow you to
type in anything regardless of if it's a date or not.
 
Back
Top