| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cells changes formatting
I have two sheets and I am linking one sheet to a second sheet. In the first
sheet the cells are formatted as accounting, the cells in the second sheet are formatted as currency. When I link sheet one to sheet two the formats on sheet two stay the same (currency) for all cells except two - they are negative numbers and they change to accounting. Can any one explain why? I would prefer them to stay as currency, how do I fix this issue? Do I need to do conditional formatting? -- Mabel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i keep my formatting when linking from one sheet to another | Excel Worksheet Functions | |||
| linking cells and formatting | Excel Discussion (Misc queries) | |||
| Linking cells in a Workbook - Formatting is lost | Excel Discussion (Misc queries) | |||
| Linking Cells -- Keep Source Cell's Formatting | Excel Discussion (Misc queries) | |||
| Linking cell formatting | Links and Linking in Excel | |||
Linear Mode
