B
Barbara
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
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