You are presumably starting with a number of different cells which are
already formatted in different ways.

If you want to split out those formatted currently with zero decimal places
you might use
=IF(CELL("format",A2)="F0",TEXT(A2,"$0"),TEXT(A2," $General"))
or if you have a choice between zero decimal places and two decimal places,
you could use
=IF(CELL("format",A2)="F0",TEXT(A2,"$0"),TEXT(A2," $0.00"))
Note that those would leave you with values as text, not numbers.

Another option, if you are happy to lose the precision of the data (and have
the value of 17.72 converted permanently to 18), would be to set
Tools/ Options/ Calculation: Precision as displayed, and then use Format/
Cells/ Custom: $General
This would leave your values as numbers, but merely lose you the precision.
--
David Biddulph

"Barbara" wrote in message
...
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