Chris’s solution worked for me. The cell format has to be set to “numerical system”, not “numbers”, for this to work. However, this will force a specific number of numerical places to be displayed. For instance, if you set it to ten and enter 001234, the cell will show as 0000001234. Setting the data type to “text” instead may be more limiting, but will completely fix this particular display issue.
Grant > On Sep 8, 2015, at 2:03:43 PM, Emilio <emilio.s.hernan...@gmail.com> wrote: > > Hello Chris, > > Appreciate your reply to my message. > I tried your method, but that did not work. > However, a solution I did find that does solve my problem is changing the > data area to text, which will preserve all digits entered into a cell. > This also is useful for credit card numbers, which is according to a post I > found through Google for users of Microsoft Excel no less. > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to macvisionaries+unsubscr...@googlegroups.com > <mailto:macvisionaries+unsubscr...@googlegroups.com>. > To post to this group, send email to macvisionaries@googlegroups.com > <mailto:macvisionaries@googlegroups.com>. > Visit this group at http://groups.google.com/group/macvisionaries > <http://groups.google.com/group/macvisionaries>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to macvisionaries+unsubscr...@googlegroups.com. To post to this group, send email to macvisionaries@googlegroups.com. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
