|
|
#2
01-23-2017, 06:32 AM
|
|||
|
|||
Your formatting in Excel only affects the display of the number. The underlying value does not change. This would affect any calculations as well since the decimals will factor in.
I think to change the value, you need to use one of the rounding functions. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Formatting Multiple Or Values | Phil H | Excel | 4 | 05-21-2015 04:16 AM |
| Conditional Formatting for values with more than 2 decimals | lynchbro | Excel | 6 | 04-17-2015 06:05 AM |
 Copying Conditional Formating
|
lynette | Excel | 2 | 03-06-2015 11:53 AM |
|
Copying and pasting values with unequal data columns
|
grexcelman | Excel Programming | 5 | 12-05-2014 11:36 AM |
|
Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode