Thread: [Solved] Excel error in inputting long numbers
View Single Post
 
Old 03-09-2016, 04:06 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
This has nothing to do with what Microsoft 'expects', but everything to do with how a computer stores numbers. One might also argue that credit card 'numbers' aren't numbers - they're a string consisting of digits with space separators. Excel allows you to input them as string.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote