| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to link a cell in date format without displaying it as 0-Jan?
Linking from one cell to any other. The from and to cell's are formatted by
date. If the from cell is blank, the to cell will automatically display 0-Jan (or any form of January 0000). I need the to cell to remain blank if the from cell is blank. Please help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to link a cell in date format without displaying it as 0-Jan?
=IF(A1="","",A1) entered in the target cell.
Gord Dibben MS Excel MVP On Wed, 1 Nov 2006 13:42:02 -0800, Jack Miller wrote: Linking from one cell to any other. The from and to cell's are formatted by date. If the from cell is blank, the to cell will automatically display 0-Jan (or any form of January 0000). I need the to cell to remain blank if the from cell is blank. Please help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to link a cell in date format without displaying it as 0-J
Thanks for your help, at first I didn't recognize that the A1 represented the
from cell Jack in California "Gord Dibben" wrote: =IF(A1="","",A1) entered in the target cell. Gord Dibben MS Excel MVP On Wed, 1 Nov 2006 13:42:02 -0800, Jack Miller wrote: Linking from one cell to any other. The from and to cell's are formatted by date. If the from cell is blank, the to cell will automatically display 0-Jan (or any form of January 0000). I need the to cell to remain blank if the from cell is blank. Please help! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to link a cell in date format without displaying it as 0-Jan?
=IF(from_cell="","",from_cell)
Biff "Jack Miller" wrote in message ... Linking from one cell to any other. The from and to cell's are formatted by date. If the from cell is blank, the to cell will automatically display 0-Jan (or any form of January 0000). I need the to cell to remain blank if the from cell is blank. Please help! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to link a cell in date format without displaying it as 0-J
Wow, thanks so much!
It works! Jack in California "Biff" wrote: =IF(from_cell="","",from_cell) Biff "Jack Miller" wrote in message ... Linking from one cell to any other. The from and to cell's are formatted by date. If the from cell is blank, the to cell will automatically display 0-Jan (or any form of January 0000). I need the to cell to remain blank if the from cell is blank. Please help! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to link a cell in date format without displaying it as 0-J
You're welcome. Thanks for the feedback!
Biff "Jack Miller" wrote in message ... Wow, thanks so much! It works! Jack in California "Biff" wrote: =IF(from_cell="","",from_cell) Biff "Jack Miller" wrote in message ... Linking from one cell to any other. The from and to cell's are formatted by date. If the from cell is blank, the to cell will automatically display 0-Jan (or any form of January 0000). I need the to cell to remain blank if the from cell is blank. Please help! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to link a cell in date format without displaying it as 0-J
Biff:
Additional help please. The IF formula you provided is just what I needed for a cell to cell within the same worksheet situation, works great! I'm having difficulty figuring out the correct sentex for the same situation, only wanting to go from 1)worksheet to worksheet within the same workbook or 2)workbook to workbook. Would you mind writing out the fomula for me using the following information? 1) File name: LinkProblem.xls Worksheet name with the FROM cell: FROM Cell location: D4 Worksheet name with the TO cell: TO Cell location: B4 2) In situation number two as discribed above, all information same except: From workbook name: LinkProblem.xls To workbook name LinkProblem2.xls I hope this isn't too much troble or bother for you, I sincerely appreciate your assistance. Jack in California From: "Biff" wrote: You're welcome. Thanks for the feedback! Biff "Jack Miller" wrote in message ... Wow, thanks so much! It works! Jack in California "Biff" wrote: =IF(from_cell="","",from_cell) Biff "Jack Miller" wrote in message ... Linking from one cell to any other. The from and to cell's are formatted by date. If the from cell is blank, the to cell will automatically display 0-Jan (or any form of January 0000). I need the to cell to remain blank if the from cell is blank. Please help! |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to link a cell in date format without displaying it as 0-J
All you have to do is open the linked file and use your mouse (pointing
device) to point to the cell references and let Excel put the path in for you. For example: Start typing the formula: =IF( Then use the mouse to select the file, navigate to the sheet and select the cell. Excel will put in the path for you. It's a lot easier than typing it in yourself especially if you have the typical ridiculously long path. Biff "Jack Miller" wrote in message ... Biff: Additional help please. The IF formula you provided is just what I needed for a cell to cell within the same worksheet situation, works great! I'm having difficulty figuring out the correct sentex for the same situation, only wanting to go from 1)worksheet to worksheet within the same workbook or 2)workbook to workbook. Would you mind writing out the fomula for me using the following information? 1) File name: LinkProblem.xls Worksheet name with the FROM cell: FROM Cell location: D4 Worksheet name with the TO cell: TO Cell location: B4 2) In situation number two as discribed above, all information same except: From workbook name: LinkProblem.xls To workbook name LinkProblem2.xls I hope this isn't too much troble or bother for you, I sincerely appreciate your assistance. Jack in California From: "Biff" wrote: You're welcome. Thanks for the feedback! Biff "Jack Miller" wrote in message ... Wow, thanks so much! It works! Jack in California "Biff" wrote: =IF(from_cell="","",from_cell) Biff "Jack Miller" wrote in message ... Linking from one cell to any other. The from and to cell's are formatted by date. If the from cell is blank, the to cell will automatically display 0-Jan (or any form of January 0000). I need the to cell to remain blank if the from cell is blank. Please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell format with Data Import (date appearing as text) | Excel Discussion (Misc queries) | |||
| Can I link a color format from 1 cell to a cell in another tab? | Excel Discussion (Misc queries) | |||
| Excel: Format Control: 'cell link' reamins constant. How to copy | Excel Worksheet Functions | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Hybrid Mode
