Formatting the numbers as text is the way to go provided you don't need to do any mathematical operations with the numbers like addition, etc.
Alan Lemly Sent from my iPhone > On Sep 8, 2015, at 4: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. > 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. -- 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.
