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!

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!

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!

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!

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!

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!

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!

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!

How to link a cell in date format without displaying it as 0-J
 

Thanks again,
I'll try it in the AM.

Jack

"Biff" wrote:

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!