I know about Ctrl+; for adding the date.
How do I add Ctrl+; in an if statement?
For example:
If I want to add the date in D1 based something ("yes") in A1,
my if statement would be something like "=if(a1= "yes", "Ctrl+;", "") ".
--
View this message in context:
http://nabble.documentfoundat
Is there a simple way to create a "date stamp" field?
Lets say I input a value in cell A1 and in cell D1 I would like to input
today date automatically. I want this to be fixed, so I can not use Today()
or Now() for that will change every day.
Any suggestions?
Thanks ahead for any input.
dave
I have a spreadsheet that I want to protect cells from being changed. I am
using cell A7 as an input cell. How can I prevent the other cells from being
changed?
Also, is there a way to turn off the cell outline border?
Thanks ahead to hopefully a simple answer
x
--
View this message in conte
By saving a spreadsheet as a csv file, I can import the values into another
program (it creates labels and btw the program is designed for it printer
only). The labels are "paired numbers"
Let say I have a column labeled A-O (starting at cell a1
A B C D E F G H and so on (this is
12:31 PM, Gene Kohlenberg [via Document Foundation
Mail Archive] wrote:
> On 1/1/2012 2:52 PM, dave_ wrote:
>
> > When I create a "Pivot data" sheet and then went I need to 'refresh' the
> > pivot data sheet (sheet 2) I am unable to do update. I have to re-cr
I close it and then open it and add to the main
spreadsheet new or delete an inventory item, it fails to update using the
refresh command in the pivot data spreadsheet (sheet 2).
Any suggestion on what to do, I would appreciate it very much.
Thanks,
-dave_
--
View this