• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

AnswerTeller

Get the Answer!

  • APPEARANCE
    • Hair
    • Skin
      • Tattoo
      • Piercing
    • Breasts
    • Makeup
    • Clothing
      • Lingerie
    • Shoes
    • Fashion
  • RELATIONS
    • Dating
    • Love
    • Friendship
    • Sex
    • Family
      • Husband
      • Wife
      • Parents
      • Brother
      • Sister
      • Children
    • Marriage
    • Divorce
    • Teenagers
    • Gifts
  • HOME
    • House
    • Apartment
    • Renting
    • Cooking
    • Garden
    • Pets and Animals
    • Car
    • Bikes
  • HEALTH
    • Maternity
  • LEARNING
    • School
    • College
    • University
    • Education
    • Exams
    • Maths
      • Algebra
      • Geometry
    • Physics
    • Chemistry
    • Anatomy
    • Quiz
  • KNOWLEDGE
    • Life
    • Religion
      • Bible
    • Books
    • History
    • Law
      • Crime
    • Science
    • Economics
    • Politics
    • International
    • Languages
  • WORK
    • Careers
    • Jobs
    • Interview
    • Business
    • Real Estate
    • Office
  • MONEY
    • Credit
    • Loan
    • Buying
    • Selling
    • Shopping
    • Insurance
    • Taxes
    • Stocks
    • E-Money
    • Gambling
    • Scam
  • LEISURE
    • Entertainment
      • Home Cinema
    • Celebrities
    • Sports
    • Movies
    • Music
    • Dancing
      • Ballet
    • Dining Out
      • Restaurants
      • Fast Food
    • Vacations
    • Holidays
      • Christmas
      • New Year
      • Easter
      • Halloween
    • Photography
  • TRAVEL
    • Accommodation
      • Hotels
      • Motels
    • Flights
    • Airlines
    • Trains
  • TRIVIA
    • Fortune
      • Horoscope
    • How To
    • How Do I
    • Puzzle
    • Quiz
    • Miscellaneous
Browse: Home / COMPUTER / Microsoft

How do I stop Microsoft excel from rounding down my numbers?

Cosplay: How do I stop Microsoft excel from rounding down my numbers?
I’m putting together a paper for medical billing codes on Microsoft Excel 2010. Problem is, with medical codes, I have numbers such as 234.0 that need to have that .0 otherwise, it would be incorrect and would be denied by insurance companies for false coding. How do I get excel to stop rounding down and making a code like 234.0 into 234? Have to have that .0 but can’t get it to stop doing so. Thanks in advance.

Answers and Views:

Answer by Hanyuu
Change the data type for the column to text, instead of general or number.

Answer by The Phlebob
That’s not actually rounding. That’s showing zero significant digits. Try this:

1. Select the cells you need to show one significant digit.
2. Right-click in the selection and select Format Cells.
3. Click the Number tab if it it’s not already selected.
4. Set the Category list box to Number.
5. Set the Decimal Places box to 1.
6. Click OK.

Hope that helps.

Related Questions:

  • 1.  How can I download to upgrade my Microsoft word 2000 to higher version?
  • 2.  How do I make a Microsoft word document my desktop background?
  • 3.  How can I set up microsoft word oe wordpad to write screenplays?
  • 4.  Why would Microsoft Security Essentials refuse to load?

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Categories

  • APPEARANCE
    • Breasts
    • Clothing
      • Lingerie
    • Fashion
    • Hair
    • Makeup
    • Shoes
    • Skin
      • Piercing
      • Tattoo
  • COMPUTER
    • Computing
    • Hardware
    • Internet
      • Google
      • Networking
      • Spam
      • Yahoo
    • Microsoft
    • Programming
    • Software
  • HEALTH
    • Maternity
  • HOME
    • Apartment
    • Bikes
    • Car
    • Cooking
    • Garden
    • House
    • Pets and Animals
    • Renting
  • KNOWLEDGE
    • Books
    • Economics
    • History
    • International
    • Languages
    • Law
      • Crime
    • Life
    • Politics
    • Religion
      • Bible
    • Science
  • LEARNING
    • Anatomy
    • Chemistry
    • College
    • Education
    • Exams
    • Maths
      • Algebra
      • Geometry
    • Physics
    • School
    • University
  • LEISURE
    • Celebrities
    • Dancing
      • Ballet
    • Dining Out
      • Fast Food
      • Restaurants
    • Entertainment
      • Home Cinema
    • Holidays
      • Christmas
      • Easter
      • Halloween
      • New Year
    • Movies
    • Music
    • Photography
    • Sports
    • Vacations
  • MONEY
    • Buying
    • Credit
    • E-Money
    • Gambling
    • Insurance
    • Loan
    • Scam
    • Selling
    • Shopping
    • Stocks
    • Taxes
  • Popular Questions
  • RELATIONS
    • Dating
    • Divorce
    • Family
      • Brother
      • Children
      • Husband
      • Parents
      • Sister
      • Wife
    • Friendship
    • Gifts
    • Love
    • Marriage
    • Sex
    • Teenagers
  • TRAVEL
    • Accommodation
      • Hotels
      • Motels
    • Airlines
    • Flights
    • Trains
  • TRIVIA
    • Fortune
    • Horoscope
    • How Do I
    • How To
    • Miscellaneous
    • Puzzle
    • Quiz
  • WORK
    • Business
    • Careers
    • Interview
    • Jobs
    • Office
    • Real Estate

Search for More!

Copyright AnswerTeller © 2025 · About · Privacy Policy · Contacts · Sitemap Disclaimer: AnswerTeller.com is an informational website, and its content does not constitute professional advice of any kind. As an Amazon Associate, we earn from qualifying purchases.