Toolsoptionscalculation and select precision as displayed

that means if you have a value that is in fact 17.71 but is displayed
as 18 then it will be converted to that. It is pretty risky to use since
calculations will not be exact

--


Regards,


Peo Sjoblom

"Barbara" wrote in message
...
Also there is formulas in some of the cells with my number list in it. I
try
to copy and paste special the column so that only VALUES are pasted, but
the
numbers change.

Are the forumlas causing me issues?





"Barbara" wrote:

I cant round the numbers to the nearest integer because they are not
consistant at all, one might go up 2 cents, the other 30 cents.

I just need Excel to stop looking at what isnt showing and format the
showing number in currency.

"Sheeloo" wrote:

Or you can simply change the FORMAT|CELLS|Number|NUMBER with 0 decimal
places...
--
To get my email id paste my address in an Excel cell and press Enter...


"Barbara" wrote:

I have a spreadsheet with a column of numbers that need formated to
currency
without rounding. This is how the numbers are listed....
18
0.95
0.75

This is what happens when I format to currency...

$17.71
$0.95
$0.75

But I needed the 17.71 to be 18.00.

There is no consistancy in the numbers in the column, some stay the
same and
some change. I dont need any of them to change values.

Please help, otherwise we are changing 16k rows manually!

Thanks so much,
Barb

I tried it and it does ok until I try to format it with decimals.
Thanks for trying,
Barbara

"Peo Sjoblom" wrote:

Toolsoptionscalculation and select precision as displayed

that means if you have a value that is in fact 17.71 but is displayed
as 18 then it will be converted to that. It is pretty risky to use since
calculations will not be exact

--


Regards,


Peo Sjoblom

"Barbara" wrote in message
...
Also there is formulas in some of the cells with my number list in it. I
try
to copy and paste special the column so that only VALUES are pasted, but
the
numbers change.

Are the forumlas causing me issues?





"Barbara" wrote:

I cant round the numbers to the nearest integer because they are not
consistant at all, one might go up 2 cents, the other 30 cents.

I just need Excel to stop looking at what isnt showing and format the
showing number in currency.

"Sheeloo" wrote:

Or you can simply change the FORMAT|CELLS|Number|NUMBER with 0 decimal
places...
--
To get my email id paste my address in an Excel cell and press Enter...


"Barbara" wrote:

I have a spreadsheet with a column of numbers that need formated to
currency
without rounding. This is how the numbers are listed....
18
0.95
0.75

This is what happens when I format to currency...

$17.71
$0.95
$0.75

But I needed the 17.71 to be 18.00.

There is no consistancy in the numbers in the column, some stay the
same and
some change. I dont need any of them to change values.

Please help, otherwise we are changing 16k rows manually!

Thanks so much,
Barb