LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell format with Data Import (date appearing as text) Louise Excel Discussion (Misc queries) 3 September 21st 06 01:57 PM
Can I link a color format from 1 cell to a cell in another tab? Greg @ Campbell Soup Excel Discussion (Misc queries) 1 September 18th 06 01:51 PM
Excel: Format Control: 'cell link' reamins constant. How to copy Rodway N Excel Worksheet Functions 0 September 7th 05 06:21 PM
Compare dates (one cell not in date format) craigcsb Excel Discussion (Misc queries) 5 June 28th 05 05:07 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"