Number won't display with decimal points

[mbderby]

I have a few cells that contain decimals that do not appear as decimals. If the number is 50.1, it only shows up as 50 in the cell. I've tried formatting it to a number with 2 decimal places and to scientific and when I do that the number displays as ##. When I do general formatting it only appears as 50.

I used a formula to pull the number into a different cell, however, and in that cell it shows up as 50.1.

Is there anything I can do to make it show up as 50.1 in the original cell?

Thanks!

[MrShorty]

I've tried formatting it to a number with 2 decimal places and to scientific and when I do that the number displays as ##.

The #### symbols are Excel's way of saying that you have asked for a number format that would be too wide to display in the given cell. Try using a smaller font or increase the column width for the cell in question.

If that is not the problem, then I suggest uploading a sample workbook.

[mbderby]

That was the problem! I feel so silly - I tried widening the cell earlier, but I guess I didn't make it wide enough. Thank you!!