Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding up entire column so each item will end in .99. How?
I am finishing up a product list for a new retail store. We have 4328
separate products, and each one I have had to enter manually by hand. Now I need to make every item end at 99 cents (.99) for the price column, but I cannot figure out how to do this with the roundup functions, or any function for that matter. I really don't want to manually go thru 4000 items again just to change the *&!*@&*!&@#! price. So if anyone has some knowledge on this, drop it. I'll love you forever. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Copy one cell to entire column | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |