Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 8th 04, 06:51 PM
Emzy Wemzy
 
Posts: n/a
Default How do I add a date formula to a cell but hide the contents with .

I'm got a spreadsheet with many different sheets in it. The first sheet is
the main page, and it holds a master table with data like customer name,
salesman, registration number, date of registration etc. The other sheets
are the individual salesman sheets, with just their relevant information
which is copied from the main page. I'm experiementing with two ways to do
this, VLOOKUP or just a formula like =sheet1!A12 etc. In the date column I
want to put the date of registration, so I can copy that from the main page.
However, sometimes a date is not always needed, so when I copy it across to
the salesman sheet, the data in the date cell reads as 00-Jan-00. I know
with somethings you can hide the contents of cells with a hyphen to show its
blank, but the formula is still there in the background. This doesnt appear
to happen when Itry this though. Can anyone please help me?!

Reply
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
Display actual contents of cell xmasbob Excel Discussion (Misc queries) 1 December 6th 04 05:09 PM
Date on two lines using a custom cell format possible? .:mmac:. Excel Discussion (Misc queries) 5 December 4th 04 09:41 PM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 02:48 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 12:07 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 12:07 AM


All times are GMT +1. The time now is 05:20 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017