| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formating- Why won't my data center
I have copied some data from one spread sheet to another. When I try to
center the data, the command does not execute. I have formated it as a currency. Any ideas? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Formating- Why won't my data center
WesleyL wrote:
I have copied some data from one spread sheet to another. When I try to center the data, the command does not execute. I have formated it as a currency. Any ideas? Thanks. This might work for you. Select the problem cells. In the Format | Cells | Number dialog, switch to Custom. It will look something like this: _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_) ^^ ^^ ^^ Delete the asterisk-space pairs. More learning he http://office.microsoft.com/en-us/ex...986791033.aspx ("Repeating characters" section) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge and Center and Center Accross Selection | New Users to Excel | |||
| formating cell with TEXT data type | Excel Discussion (Misc queries) | |||
| Bar Graph - Values from one cell, data from another FAST formating | Excel Discussion (Misc queries) | |||
| Cells not formating (won't center) | Excel Discussion (Misc queries) | |||
| Is there a keyboard shortcut to center data in a cell? | Excel Worksheet Functions | |||
Linear Mode
