| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fomatting currency
I have a file that was brought into excel in one column, example 5146900. It
is money that should be $51,469.00. When I go to format this as currency it adds two decimals at the end $5,146,900.00, I want it fomatted as $51,459.00. How do I get it to use the last two numbers as the cents? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Editing (Fomatting) | Excel Discussion (Misc queries) | |||
| Conditional Worksheet Fomatting | Setting up and Configuration of Excel | |||
| Conditional Fomatting 3 in code | Excel Discussion (Misc queries) | |||
| conditional fomatting | Excel Worksheet Functions | |||
| can't stop auto fomatting - help | Excel Discussion (Misc queries) | |||
Threaded Mode
