Change the way numbers are displayed in Excel 2003 SP2
 

I inherited an excel spreadsheet that contains a lot of data. All the
numbers in this spreadsheet are formatted in the millions. (ex: 6,000,000) I
would like to change the formatting of the numbers to just display the 6 as
opposed to showing commas and decimal places. I have tried the decrease
decimal, but that did not work. I tried the round formula, the Rounddown
formula, and the Mround formula, but I cant get them to just display the
first digit.

Is there a way to tell Excel to drop all commas, and decimal places in large
numbers?

Thanks, :)

Change the way numbers are displayed in Excel 2003 SP2
 

one way:

Format/Cells/Number/Custom 0,,

In article ,
Marilyn wrote:

I inherited an excel spreadsheet that contains a lot of data. All the
numbers in this spreadsheet are formatted in the millions. (ex: 6,000,000) I
would like to change the formatting of the numbers to just display the 6 as
opposed to showing commas and decimal places. I have tried the decrease
decimal, but that did not work. I tried the round formula, the Rounddown
formula, and the Mround formula, but I cant get them to just display the
first digit.

Is there a way to tell Excel to drop all commas, and decimal places in large
numbers?

Thanks, :)

Change the way numbers are displayed in Excel 2003 SP2
 

So instead of showing 6,000,000 you just want to show 6. You can use a custom
format something like this...

0,,

--
HTH...

Jim Thomlinson


"Marilyn" wrote:

I inherited an excel spreadsheet that contains a lot of data. All the
numbers in this spreadsheet are formatted in the millions. (ex: 6,000,000) I
would like to change the formatting of the numbers to just display the 6 as
opposed to showing commas and decimal places. I have tried the decrease
decimal, but that did not work. I tried the round formula, the Rounddown
formula, and the Mround formula, but I cant get them to just display the
first digit.

Is there a way to tell Excel to drop all commas, and decimal places in large
numbers?

Thanks, :)

Change the way numbers are displayed in Excel 2003 SP2
 

Thanks to the both of you!!!! It worked GREAT!

:)

"JE McGimpsey" wrote:

one way:

Format/Cells/Number/Custom 0,,

In article ,
Marilyn wrote:

I inherited an excel spreadsheet that contains a lot of data. All the
numbers in this spreadsheet are formatted in the millions. (ex: 6,000,000) I
would like to change the formatting of the numbers to just display the 6 as
opposed to showing commas and decimal places. I have tried the decrease
decimal, but that did not work. I tried the round formula, the Rounddown
formula, and the Mround formula, but I can€„¢t get them to just display the
first digit.

Is there a way to tell Excel to drop all commas, and decimal places in large
numbers?

Thanks, :)