HELP FORMATING COLUMNS
Normally VBA would be used to handle that circumstance, but this trick is
occaisionally useful: €¢ Set the DV on the cells €¢ Format those cells to be Unlocked €¢ Format the contiguous cells to the right of the DV cells to be Locked. €¢ For each horizontal pair of cells, merge those two cells €¢ Turn on sheet protection Now users can enter any 7-char value into the cells...but they cannot copy/paste into the DV cells. Is that something you can work with? *********** Regards, Ron XL2002, WinXP "JTEFUN" wrote: Is there anything else that I could try? -- JTEFUN "Ron Coderre" wrote: Try Data Validation: Select the range of cells to be impacted From the Excel main menu: <data<validation Allow: Text Length Data: Equal to Length: 7 Click [OK] Note_1: Depending on the Error Alert options you select, you can prevent non-7-char entries....or just warn the user. Note_2: Users will stil be able to copy/paste invalid entries in the DV range. Is that an issue?. Is that something you can work with? (Post back with more question) *********** Regards, Ron XL2002, WinXP "JTEFUN" wrote: I need to beable to format collumns to only acept 7 characters, but then in column B only 2 characters is this something that is possible? -- JTEFUN |
All times are GMT +1. The time now is 03:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com