| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date of worksheet comes out numbers on other linked worksheet
The main worksheet has total 10 column/projects. Each column/project has a
separate worksheet. I copied the column/project from the main worksheet and then did a "paste link" onto the separate worksheet so that anything on the main worksheet that changes will automatically update on the individual worksheet. Question #1: The date field shows up as numbers on the separate worksheet and not the date that is on the main worksheet. What formula is needed that will automatically be posted on the separate worksheet? Question #2: What formula is needed for the separate worksheet cell to be blank? I hope this makes sense. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date of worksheet comes out numbers on other linked worksheet
Hi,
Q1. The cell sounds like it is formatted as General so fromat as a date. Q2. I don't understand the question. Mike "Deb A" wrote: The main worksheet has total 10 column/projects. Each column/project has a separate worksheet. I copied the column/project from the main worksheet and then did a "paste link" onto the separate worksheet so that anything on the main worksheet that changes will automatically update on the individual worksheet. Question #1: The date field shows up as numbers on the separate worksheet and not the date that is on the main worksheet. What formula is needed that will automatically be posted on the separate worksheet? Question #2: What formula is needed for the separate worksheet cell to be blank? I hope this makes sense. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date of worksheet comes out numbers on other linked worksheet
1. Format the cells on the other sheets as Date
2. =IF(Sheet1!A1="","",Sheet1!A1) You cannot create the formula using "paste link" You must enter it then copy down and across in target sheet. Gord Dibben MS Excel MVP On Wed, 16 Jul 2008 11:32:00 -0700, Deb A wrote: The main worksheet has total 10 column/projects. Each column/project has a separate worksheet. I copied the column/project from the main worksheet and then did a "paste link" onto the separate worksheet so that anything on the main worksheet that changes will automatically update on the individual worksheet. Question #1: The date field shows up as numbers on the separate worksheet and not the date that is on the main worksheet. What formula is needed that will automatically be posted on the separate worksheet? Question #2: What formula is needed for the separate worksheet cell to be blank? I hope this makes sense. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating Date on all worksheets linked to master worksheet | Excel Worksheet Functions | |||
| copy date from worksheet to another worksheet (same File0 | Excel Discussion (Misc queries) | |||
| Variable worksheet name (tab) linked to cell in same worksheet | Excel Worksheet Functions | |||
| Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
| How do I copy a date in a worksheet cell to another worksheet? | Excel Worksheet Functions | |||
![Deb A[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
