Answered By: Arnetta Henderson Last Updated: Aug 16, 2019 Views: 31
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
- About the Library
- Textbook Checkout & Course Reserves
- Printing
- Books
- Library Lab
- Articles
- COM
- Databases
- Borrowing Library Items
- Citation/Style: MLA
- Microsoft Word
- COM: Bookstore
- Research
- Distance Ed
- eBooks
- Hot or Controversial Topics
- Database: EBSCO
- Citation/Style: APA
- Database: OneSearch
- Citation
- Computers & Tech (Help)
- Fax/Scan
- Literature
- American Literature
- Home Access
- Microsoft PowerPoint
- Nursing
- COM: ID
- Internet
- Adobe
- Health & Medicine
- Faculty
- Copiers
- American History
- GED
- English
- Social Sciences
- Government & Law
- Study Guides, Tests & Testing
- Scholarly/Peer Reviewed
- Database: EBSCO eBooks
- Files & Drives
- Psychology
- Database: Literary Sources
- Papers & Writing
- Study Rooms
- Wi-Fi
- Database: CINAHL
- Blackboard
- Interlibrary loan (ILL)
- Database: Literary Reference Center
- Research Tutorial
- Speech
- COM: WebAdvisor
- Science
- Media
- Literary Criticism
- History
- Database: Opposing Viewpoints
- British Literature
- Database: Academic Search Complete
- Database: ProQuest
- Adult Education
- Games & Puzzles
- World History
- Database: Gale eBooks
- Education
- Guides
- Careers
- Database: Issues & Controversies
- Database: Literature & Language
- Library Fees
- Biology
- Humanities
- Database: Gale
- Microsoft Excel
- Business
- Reference
- Computers & Tech (Research)
- Microsoft Office 365
- Industrial
- Philosophy
- World Literature
- Database: Films on Demand
- Primary Sources
- Database: Hoopla
- Microsoft Office
- MAC
- Texas
- Math
- Journals
- YouTube
- Ethics
- Communication
- Google Scholar
- Religion
- Crtitcal Thinking & Information Literacy
- News
- Local
- Criminal Justice
- CHS
- Database: Facts on File
- Streaming Media
- Database: LearningExpress
- Gender
- Database: CQ Researcher
- Drama
- African Americans
- Citation/Style: GSA
- Database: JSTOR
- Sociology
- Statistics
- Mobile
- iOS, iTunes
- zoterbib
- Coronavirus
- Database: Britannica
- Geography & Travel
- COM History
- Athletics & Sports
- Film
- Citation/Style: Chicago
- Database: World News Digest
- Fine Arts
- COM: Course Evaluations
- Nutrition
- Environment
- Poetry
- Language
- Open Access
- Art
- Music
- Economics & Finance
- Native Americans
- Scan
- Database: CREDO
- Geology
- Welding
- Citation/Style: ACS
- Testing
- Plagiarism
- ESL
- Chemistry
- British History
- Hispanic
- Undead
- Citation/Style: Harvard
- Stephen King
- Library Spaces
- Child Development
- Astronomy
- Copyright & Fair Use
- Database: Health Reference Center Academic
- Yahoo!
- LGBT
- Advising and Student Support
- Copyright & Fair Use for Faculty
- Reading
- Photography
- Texas History
- Citation/Style: ASA
- Citation/Style: Turabian
- Spanish
- Database: Swank
- Media Services
- Microsoft Outlook
- Safety
- Citation/Style: AMA
- Kindle
- Disasters
- Database: Science Online
- College Success Academy
- Holds
- Cosmetology
- Anthropology
- Botany
- Pages for MAC
- Microsoft Windows
- EMS
- Mythology
- Genetics
- Android
- Database: Science in Context
- Social Work
- Law
- calculators
- Bias
- Database: Academic Video Online (AVON)
- Database: WorldCat
- Firefighting
- Physics
- Anatomy
- Fashion
- SAT
- Library Instruction
- Database: Vocational & Career Collection
- Sports
- Genealogy
- Taxes
- Bibliography
- Google Docs
- COM Learning Locations
- Database: American History Online
- Microsoft Access
- LibChat
- Asian Americans
- Database: Consumer Health Complete
- Database: STAT!Ref
- Roku
- Google Slides
- Accessibility