Cell formats WILL NOT match in a range of cells

K

kgartin

Board Regular
Joined
May 6, 2010
Messages
201
I have a range of cells whose format I CANNOT get to match no matter what I do! I select the entire range and change the number formatting and some change and the others remain the same. Craziest thing ever! What the heck is going on?

All conditional formatting in the sheet has been deleted.
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Sort by date Sort by votes
What kind of data is not matching? Can you give an example? What format are you using?
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
VBA Code to Add a Comment to a Cell based on that Cells Content
2
Replies
11
Views
130
albert_de
A
J
  • Solved
Dont fix cell colour if cell has no Interior colour or Conditional Formatting
2
Replies
11
Views
337
Joe4
Joe4
A
  • Question
Conditional formating (with range) but instead of the color/formating of the certain cell to get values inside the matching cells in the range?
Replies
1
Views
169
aircarrier
A
R
  • Solved
How to determine item selection in multi-select listbox without VBA?
Replies
3
Views
103
Micron
M
SaraWitch
  • Solved
Conditionally Format row if formula in cell returns a date
Replies
2
Views
334
SaraWitch
SaraWitch

Forum statistics

Threads
1,214,643
Messages
6,120,702
Members
448,980
Latest member
CarlosWin

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top