Can't Change Number of Digits After Decimal

Hello all,

I've attempted to change the number of digits shown via the 'Format Cells' right click option and the decimal button in the ribbon to no avail. Any idea as to why it won't take? Yes, I've tried different options in the drop down menu of the ribbon and options on the left of 'Format Cells'. The prior owner of the spreadsheet had the 5150.5 as "General" in the drop down.

decimal1.PNG decimal2.PNG decimal3.PNG

Originally Posted by shg

It looks like the number is stored as text.

Select the column, Data > Text to columns, Finish.

Then try formatting.

I attempted that and no joy.

Originally Posted by avk

Its a format problem. If you attach your sample file its more helpful.

Attachment's aren't working correctly...
attachment issue.png

To attach a file to your post,

• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post

Here you go and thank you

Originally Posted by sandy666

You've spaces in front and at the end of every value in rows 4 & 5 so this is a text not a number

Sigh...is there a way to edit this in mass vs individual?

refresh thread, I added formula and your example file with result (post #8)

or use this in A8: =--TRIM(CLEAN(SUBSTITUTE(A4,CHAR(160),""))) the drag down to A9 and with both selected drag to the right as far as you need.
next copy selected range, right click on A4 and paste as values, then delete rows A8 & A9