| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to Format Currency without changing values - over 16,0000 row
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trying to change 000-000-0000 phone format to (000)000-0000 ???? | Excel Worksheet Functions | |||
| Changing cell format from text to currency | Excel Worksheet Functions | |||
| changing cell values with text and currency | Excel Discussion (Misc queries) | |||
| Phone number format from 000.000.0000 to (000)000-0000 | Excel Discussion (Misc queries) | |||
| Changing format of column from "general" to "currency" | Excel Discussion (Misc queries) | |||
Threaded Mode
