+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: Date format in Spreadsheet App (/thread-22406.html)
Date format in Spreadsheet App - GSL007 - 09-26-2024 07:06 PM
Can somebody please tell me how I can enter a date field or date into the spreadsheet app?
Also I understand I need to change my password for this site in the control panel but I can't find the control panel anywhere? Must be blind.
Gary
RE: Date format in Spreadsheet App - KeithB - 09-26-2024 07:15 PM
For the control panel, just click on your name in blue after the "Welcome Back" Or the "User CP" at the end of that line
RE: Date format in Spreadsheet App - GSL007 - 09-26-2024 07:36 PM
Thank you, Keith.
RE: Date format in Spreadsheet App - BruceH - 09-26-2024 09:10 PM
(09-26-2024 07:06 PM)GSL007 Wrote: Can somebody please tell me how I can enter a date field or date into the spreadsheet app?
I don't believe it can format dates the way PC based spreadsheets do. Instead you just use a float in the format yyyy.mmdd as you do for date functions like DATEADD() or DDAYS().
Type DATEADD() and press Help for some examples.
RE: Date format in Spreadsheet App - Tyann - 09-27-2024 05:15 AM
Bonjour
Vous pouvez :
1) écrire une fonction qui formate la date sous forme de chaîne par exemple
2) appeler cette fonction depuis une cellule du tableur.
J'ai écrit une fonction qui fait cela si vous voulez ?
Hello
You can:
1) write a function that formats the date as a string for example
2) call this function from a spreadsheet cell.
I've written a function that does this if you like?
RE: Date format in Spreadsheet App - GSL007 - 10-07-2024 01:39 AM
That might be helpful,
Merci