Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Very Simple formatting Question
I thought I understood most aspects of formatting numbers and text in Excel
until this came up... I have a spread sheet with numbers. I select the numbers and then right click to Format Cells and I select currency. The spread sheet seems to ignore the currency formatting and does not put in the dollar signs. What is worse than that is the column of numbers will not sort correctly. If I sort it gives me an incorrect sort order like: 119.42 12.62 120.38 122.43 Any idea what is going on? Quin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple graph formatting question for dates. | Excel Discussion (Misc queries) | |||
Simple formatting question.... | Excel Discussion (Misc queries) | |||
Conditional formatting, simple question... | Excel Worksheet Functions | |||
Conditional formatting--simple question | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) |