Places after decimal

golfnut324

Board Regular
Joined
Jul 12, 2006
Messages
93
I should know this by now but I can't figure it out. How do I limit the number of digits after the decimal point? Here's an example:

Cell C8 shows 12.49 BUT the formula bar shows it as 12.496785543. Problem is, when I use the data in cell C8 somewhere else I expect it to be used as 12.49 but I get 12.496785543.

Can anyone tell me how to fix this?

Thanks for helping.
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,109,331
Messages
5,528,060
Members
409,799
Latest member
camronmartin

This Week's Hot Topics

Top