Ubuntu
openoffice.org package

look up date format for date in open office calc

Asked by FlyOutlaw

i want to have a cell look at the computer and get the current date when I resave the file and print it.

want it to put the date in the cell and then print it.

Thanks

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Tony Pursell
Solved:
Last query:
Last reply:

This question was reopened

Revision history for this message
FlyOutlaw (nisaacs-ntwifi) said : 		#1

not a bug just don't know how to format a cell for the current date and have it put it in a certain cell and then when I save the file it has that date in the data. I know it can be done just cannot find out how in open office. could do it in Excel

Thanks

Revision history for this message
Vu Do Quynh (vu-do-quynh) said : 		#2

Is the function =TODAY() that you are looking for ?

Put it in a Calc cell and it will enter the date of the system in that cell.

Revision history for this message
FlyOutlaw (nisaacs-ntwifi) said : 		#3

Thanks that is it now to figure out how to keep it and not lose it.

Thanks Much

Revision history for this message
FlyOutlaw (nisaacs-ntwifi) said : 		#4

Thanks Vu Do Quynh, that solved my question.

Revision history for this message
FlyOutlaw (nisaacs-ntwifi) said : 		#5

Yes the definetly solved my problem but opened another question.

does this function work in a text document in open office?

Sorry to bother you,.
Thanks in advance.
Nolan

Revision history for this message
Best Tony Pursell (ajpursell) said : 		#6

Yes, go Insert > Fields > Date

Or Insert > Fields > Other > Document tab > Type = Date > Select = Date [*not* Date (fixed)]> Format = (type of date you want)

Tony

Revision history for this message
FlyOutlaw (nisaacs-ntwifi) said : 		#7

Vu Do Quynh And Tony for all the help this solved my problems for today

Thanks very much

Nolan

Revision history for this message
FlyOutlaw (nisaacs-ntwifi) said : 		#8

Thanks Tony Pursell, that solved my question.

Revision history for this message
FlyOutlaw (nisaacs-ntwifi) said : 		#9

couldn't ask for better service or anyone nicer

Thanks again