View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wescotte Wescotte is offline
external usenet poster
 
Posts: 28
Default Data validation/Formatting input

Is it possible to force the user to enter text in a very specific
format like for entering dates or similar syntax specific input?

Also, I setup a custom format of 0000"."0000"."00

When the user enters 123 it it switched to
0000.0001.23

Is it possible to reverse it so it would become 1230.0000.00 instead?

Thanks
Eric