Answered By: Arnetta Henderson Last Updated: Aug 16, 2019 Views: 19
The operating system that you are using does not make a difference in the format of the type of numbers that you enter into Excel. When you enter a general number and it is not showing up the way that you would like for it to show, this could be any number of reasons.
A cell may display ##### when it contains data that has a number format that is wider than the column width. To increase the width of the column, point to Column on the Format menu, and then click AutoFit Selection.
In Microsoft Excel, the appearance of a number in a cell is separate from the number that is stored in the cell. When a number that you enter is rounded, in most circumstances, only the display of the number is rounded. Calculations use the actual number stored in the cell, not the number as it is displayed. You can change the display of numbers on the Number page of the Format Cells dialog box (Format menu, Cells command).
Links & Files
Was this helpful? 0 0
Comments (0)
Answers by Topic
- Textbook Checkout & Course Reserves
- About the Library
- Printing
- Books
- Library Lab
- COM
- Articles
- Databases
- Borrowing Library Items
- Citation/Style: MLA
- Microsoft Word
- COM: Bookstore
- Research
- Database: EBSCO
- Distance Ed
- Hot or Controversial Topics
- Citation/Style: APA
- eBooks
- Computers & Tech (Help)
- Fax/Scan
- American Literature
- Copiers
- Home Access
- Microsoft PowerPoint
- Literature
- Nursing
- COM: ID
- Internet
- Adobe
- Faculty
- Health & Medicine
- American History
- Citation
- English
- GED
- Social Sciences
- Government & Law
- Study Guides, Tests & Testing
- Files & Drives
- Database: Literary Sources
- Psychology
- Study Rooms
- Database: Academic Search Complete
- Scholarly/Peer Reviewed
- Papers & Writing
- Wi-Fi
- Database: Literary Reference Center
- Blackboard
- Database: EBSCO eBooks
- Interlibrary loan (ILL)
- COM: WebAdvisor
- Research Tutorial
- Speech
- Database: CINAHL
- Science
- Database: OneSearch
- British Literature
- Media
- History
- Database: Opposing Viewpoints
- World History
- Guides
- Education
- Adult Education
- Games & Puzzles
- Careers
- Database: Issues & Controversies
- Database: Gale eBooks
- Library Fees
- Biology
- Humanities
- Microsoft Excel
- Business
- Reference
- Microsoft Office 365
- Database: Research Library
- Industrial
- Computers & Tech (Research)
- Math
- Philosophy
- Literary Criticism
- World Literature
- Primary Sources
- Database: Literature & Language
- Database: Films on Demand
- Microsoft Office
- MAC
- Database: Hoopla
- YouTube
- Journals
- Texas
- Local
- Communication
- Crtitcal Thinking & Information Literacy
- Ethics
- Database: CQ Researcher
- News
- Database: Facts on File
- CHS
- Gender
- Database: America's News
- Google Scholar
- Religion
- African Americans
- Citation/Style: GSA
- Criminal Justice
- Sociology
- Streaming Media
- Mobile
- Database: Gale
- iOS, iTunes
- Coronavirus
- Statistics
- Geography & Travel
- Film
- Nutrition
- COM History
- Athletics & Sports
- Drama
- Poetry
- Open Access
- Fine Arts
- Art
- Database: Health Reference Center Academic
- Citation/Style: Chicago
- COM: Course Evaluations
- Database: LearningExpress
- Economics & Finance
- Geology
- Environment
- Native Americans
- Database: Britannica
- Database: CREDO
- Welding
- Citation/Style: ACS
- Language
- Scan
- Plagiarism
- ESL
- Music
- British History
- Hispanic
- Undead
- Citation/Style: Harvard
- Stephen King
- Astronomy
- Yahoo!
- LGBT
- Library Spaces
- zoterbib
- Advising and Student Support
- Copyright & Fair Use for Faculty
- Reading
- Chemistry
- Photography
- Texas History
- Citation/Style: ASA
- Citation/Style: Turabian
- Copyright & Fair Use
- Media Services
- Child Development
- Microsoft Outlook
- Citation/Style: AMA
- Kindle
- Disasters
- Database: Science Online
- Database: Swank
- Holds
- Cosmetology
- Anthropology
- Botany
- Safety
- Pages for MAC
- Microsoft Windows
- Mythology
- Genetics
- Android
- Database: Science in Context
- College Success Academy
- Social Work
- Spanish
- Law
- Bias
- Physics
- Anatomy
- Fashion
- SAT
- Library Instruction
- Database: Vocational & Career Collection
- Sports
- Genealogy
- Taxes
- Bibliography
- Google Docs
- calculators
- Testing
- Database: WorldCat
- EMS
- Firefighting
- Microsoft Access
- LibChat
- Asian Americans
- Database: Consumer Health Complete
- Database: STAT!Ref
- Roku
- Google Slides
- COM Learning Locations
- Accessibility