Welcome to MacForumz.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Date Stamp in MS Excel Spreadsheet

 
   Macintosh computer (Home) -> Excel RSS
Related Topics:
Use Excel spreadsheet in Entourage calendar? - Hello, can I set up my Entourage calendar to tie in with dates set up in an Excel I have applied a formula to tally my bills and would like to have this in my Entourage calendar so I can see Thanks.

Entering data into Excel spreadsheet - Using Office 2008 on IMAC 24, Leopard 10.5.2 When I input ANY number into an excel it divides by 10. 10000 become 1000 1 becomes .1 Help!

Want to open tables in browser page in Excel spreadsheet - Does anyone know of a tool that can convert HTML tables in a browser (Firefox) page to a form that can be opened into an Excel Mike

macintosh works 3.0 spreadsheet filet export to excel w/ n.. - how do i transfer a macintosh works 3.0 file to any version of excel that operates in any version of mac operating an excel in mac os 9.2 classic or mac os 10.4 this works file, several cells have

Date Formatting in Excel 2004 - Hopefully someone can help. When I copy data with a list of dates from one Excel file to another the copied data bears no to the original date, even when I paste special - formats. For example 10/2/04 becomes 11/2/08. The original Excel..
Next:  Excel: Lots of unanswered Excel quetsions  
Author Message
kenn

External


Since: Dec 04, 2007
Posts: 1



(Msg. 1) Posted: Tue Dec 04, 2007 10:33 am
Post subject: Date Stamp in MS Excel Spreadsheet
Archived from groups: microsoft>public>mac>office>excel (more info?)

I use a form written in MS XL that has a cell with a date formula of
=TODAY(). Every time I open this blank form (I have one for each
customer with that customers billing information on it) to enter a new
order for that customer, the date is automatically entered. Very
handy. However, after the current job information is entered and I
save that form as "ABC Development-XYZ Property", and then re-open it
3 days later to add something to it, I would like the date in the
date cell to be the date that I used originally, not today's date.
Any way to do that automatically???

 >> Stay informed about: Date Stamp in MS Excel Spreadsheet 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3828



(Msg. 2) Posted: Tue Dec 04, 2007 11:38 am
Post subject: Re: Date Stamp in MS Excel Spreadsheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In article
<c57d4cbb-6e2f-423d-8a06-28e20efbd595 DeleteThis @d27g2000prf.googlegroups.com>,
kenn DeleteThis @cdiblinds.com wrote:

> I use a form written in MS XL that has a cell with a date formula of
> =TODAY(). Every time I open this blank form (I have one for each
> customer with that customers billing information on it) to enter a new
> order for that customer, the date is automatically entered. Very
> handy. However, after the current job information is entered and I
> save that form as "ABC Development-XYZ Property", and then re-open it
> 3 days later to add something to it, I would like the date in the
> date cell to be the date that I used originally, not today's date.
> Any way to do that automatically???

See

http://www.mcgimpsey.com/excel/timestamp.html

 >> Stay informed about: Date Stamp in MS Excel Spreadsheet 
Back to top
Login to vote
Display posts from previous:   
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]