Quicker Way?

Sharkie21

Active Member
Joined
Nov 2, 2005
Messages
319
Is there a quicker way to make each of my cells be in millions instead of going through each cell and dividing it by a million? Or at least make my graph represent the numbers in millions?
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
Custom format your cells (or axis) as #,##0.00,, or similar (with two ,'s at the end)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,112
Messages
5,570,259
Members
412,314
Latest member
yazanwael
Top