| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding dates
Hi,
I have created a workbook which has a number of fields in worksheet one. When data is keyed into this sheet the two other sheets in the workbook are populated. One of the sections requires dates to be put in. When no date is entered the other sheets default to "00/01/1900". is there a way of keeping these cells blank until a date is entered in the first sheet? Thanks, bryan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding dates
Hi
The usual way is to use something like this: =IF(Sheet1!B90,Sheet1!B9,"") Hope this helps. Andy. "Bryan" wrote in message ... Hi, I have created a workbook which has a number of fields in worksheet one. When data is keyed into this sheet the two other sheets in the workbook are populated. One of the sections requires dates to be put in. When no date is entered the other sheets default to "00/01/1900". is there a way of keeping these cells blank until a date is entered in the first sheet? Thanks, bryan |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding dates
Are you using formula to populate the other sheet? If so, test the value
first,,like this =IF(Sheet1!A1="","",Sheet1!A1) -- HTH RP (remove nothere from the email address if mailing direct) "Bryan" wrote in message ... Hi, I have created a workbook which has a number of fields in worksheet one. When data is keyed into this sheet the two other sheets in the workbook are populated. One of the sections requires dates to be put in. When no date is entered the other sheets default to "00/01/1900". is there a way of keeping these cells blank until a date is entered in the first sheet? Thanks, bryan |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding dates
Thanks Andy/Bob - Problem solved!
Cheers, Bryan "Andy" wrote: Hi The usual way is to use something like this: =IF(Sheet1!B90,Sheet1!B9,"") Hope this helps. Andy. "Bryan" wrote in message ... Hi, I have created a workbook which has a number of fields in worksheet one. When data is keyed into this sheet the two other sheets in the workbook are populated. One of the sections requires dates to be put in. When no date is entered the other sheets default to "00/01/1900". is there a way of keeping these cells blank until a date is entered in the first sheet? Thanks, bryan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTables - Group Dates, excluding dates | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
| Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Linear Mode
