| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom number format
Thank you so much. It worked great.
Alejandra "Dave Peterson" wrote: Oops. That second one should have been: _($* #,###.#,_);_($* (#,###.#,);_($* "-"??_);_(@_) or maybe _($* #,###.0,_);_($* (#,###.0,);_($* "-"??_);_(@_) (.# was changed to .0 and I screwed it up) Dave Peterson wrote: I'd try: _($* #,###.#,_);_($* (#,###.#,);_($* "-"??_);_(@_) or maybe _($* #,###.0,_);_($* (#,###.0#,);_($* "-"??_);_(@_) ACotton wrote: I need the following number to look as follows: Is: $ 1,075,245 Want: $ 1,075.2 Not all of the numbers are millions so I want the $ to line up to the left and decimal to line up too. Thanks in advance for any help. Alejandra -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a custom number format in Excel using a symbol? | Excel Discussion (Misc queries) | |||
| Custom Number Format | Excel Discussion (Misc queries) | |||
| Custom Number format question | Excel Discussion (Misc queries) | |||
| Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) | |||
| How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
Threaded Mode
