Numbers in cells getting cut off (and rounded as well) in Excel 2007

Hi, folks.  I'm very new to Excel and am having a weird issue.  I entered a bunch of dollar amounts in various cells, then saved the document and when I reopened it, the left-most digits in SOME of the cells have been cut off halfway through the number.  Then, when I look in the Formula Bar at those cells, it shows that those numbers have also been rounded off (rounded up, actually).

Has anyone experienced this before?  I've tried a few easy fixes (e.g., restarting the computer, re-saving the document with a different name, changing the viewing resolution of the screen, etc.) but I have not reinstalled Excel or anything.

Any help would be greatly appreciated.

Thanks!

-Greg

 

P.S. In case it matters, Windows 7 Ultimate 64-Bit, Intel i7 chip.

 

Question Info


Last updated October 25, 2019 Views 7,444 Applies to:
Answer
Answer

First, do you want to show the decimals, if so change the format of the numbers to something that shows all the digits-  Home, Number Format dropdown, choose Number.

In your earlier post you didn't seem to want the numbers rounding (by the way they are not rounding, this is a format, it displays as though it were rounded, but the underlying number is retained unrounded)  Formatting doesn't "round" UP it "round" up or down depending of the digits not being displayed.

If you don't want to display the decimal places use the Number format I mentioned above and then click the Decrease Decimals button on the Home ribbon, in the Number group.

As to why your numbers are being cut off on the left, need to see it.  The best way to share a file, allow others to help, and maintain everyone's privacy, is to post it to one of the free file-sharing sites and post the link here.

These are a few candidates:
MediaFire: http://www.mediafire.com/
FileFactory: http://www.filefactory.com/
FileSavr: http://www.filesavr.com/
FileDropper: http://www.filedropper.com/

let us know where you post it and what its called.


If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire
Shane Devenshire

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.