On Fri, Oct 14, 2011 at 10:27 AM, Daniel Rodriguez <[email protected]> wrote:
> When you change the format from General to Text, Text will allow the
> leading 0 to treated as a text character and it will be displayed as entered.
Alternatively, use a Custom format to pad with zeros. For example,
if you have 5 digit numbers and you want them all to be padded with
leading zeros if they don't have 5 significant digits, apply a Custom
format of:
00000
Which approach is "better" depends on circumstances.
You can also use Custom formats for things like dashes in phone
numbers or SSNs, etc.
-- Ben
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to [email protected]
with the body: unsubscribe ntsysadmin
