And what happens to the dollar signs when you do the Paste Special/
Multiply?
--
David Biddulph

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
Barbara,

As you would have seen by the different responses, there is no simple way
to
do it you want different things for different cells.

David's formula will do what you want to do. You will need to convert them
back to numbers then which you can do by
entering 1 somewhere
copying it
selecting your column and choosing Edit|Paste Special|Multiply

or you can send the file to me... I will do the needful and send it
back...
--
To get my email id paste my address in an Excel cell and press Enter...


"Barbara" wrote:

Is there any way to format what is showing?
Barbara




"Sheeloo" wrote:

Barbara,

The number you see as 18 is actually 17.71 that is why when you change
the
format to currency it shows as 17.71.

If you select the cell showing 18 and look in the EDIT BOX you will see
it
shows 17.71 or something similar...
--
To get my email id paste my address in an Excel cell and press Enter...


"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