How do you establish a character limit for a cell? I have a form that we have our employees complete that requires a 16 digit number. Every time we enter a 16 digit number into the cell, it turns the 16th number into a zero or puts it into scientific notation. My thought was that I would establish 4 consecutive cells that would take only 4 numbers each and once it reached the fourth number it would move over to the next box. However, I don't know how to format that.
Hi,
Change the number format of your cell to "String" to keep the 16 digits in the cell
(Select the Cell, then CTRL+1, select Text)
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
You can certainly use Data Validation to limit the character length to 4. data/DataValidation/Text length
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Is it actually a 16-digit number or is it a 16-character numeric text string? If the latter, format the cells as text. You can do that even if it is a number and when processing via any calculation use the VALUE() function.
If you limit it to 4 characters, is there a way that once the user has reached 4 characters, it will automatically tab to the next cell?
Yes, only with a macroIf you limit it to 4 characters, is there a way that once the user has reached 4 characters, it will automatically tab to the next cell?
Thanks, but I don't want to do that. We will just format as text and keep it as 16 characters.
Thanks to all for help.
OK. Glad to have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks