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?!

Hi
try something like
=IF(sheet1!A12="","",sheet1!A12)

--
Regards
Frank Kabel
Frankfurt, Germany

"Emzy Wemzy" <Emzy schrieb im
Newsbeitrag ...
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?!

Tools
Options
View
untick the zero values box
"Emzy Wemzy" <Emzy wrote in message
...
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?!