Mobile menu

Excel changes date on invoice
Thread poster: Louise Dupont

Louise Dupont  Identity Verified
Canada
Local time: 20:49
English to French
May 3, 2004

I use Excel for invoices. After I finish a project I send the invoice to my client and print a copy for my files. The problem is: when I re-open the invoice a couple of days later, the date is changed automatically to the current date.
Can I stop Excel from doing this?

I tried to change the cell content to "Text" so it will not recognize it as the date, but it still does....

Thanks!


Direct link Reply with quote
 

Ralf Lemster  Identity Verified
Germany
Local time: 02:49
English to German
+ ...
What formula or function did you enter? May 3, 2004

Hi Louise,
Sounds as if you used a date function for that cell - what exactly did you enter?

Ralf


Direct link Reply with quote
 

Louise Dupont  Identity Verified
Canada
Local time: 20:49
English to French
TOPIC STARTER
Excel models May 3, 2004

I use the Excel models, and I only changed a couple of details to customize it.
I know that the formula is the problem, how can I change it?
When I click on the date, I see "DATA1" in the box, and I cannot change anything.


Direct link Reply with quote
 

Ralf Lemster  Identity Verified
Germany
Local time: 02:49
English to German
+ ...
You need to change the cell contents May 3, 2004

Aha....
I use the Excel models, and I only changed a couple of details to customize it.
I know that the formula is the problem, how can I change it?

Normally, by just overwriting its contents.

When I click on the date, I see "DATA1" in the box, and I cannot change anything.

If you're using Excel templates provided, you may need to unprotect that cell in order to change it.

HTH, Ralf


Direct link Reply with quote
 

Nedzad Selmanovic
Local time: 02:49
English to Bosnian
+ ...
Use Adobe Acrobat May 4, 2004

If you use Adobe Acrobat (full version) it will incorporate into MS Word and MS Excel, and you have an opportunity to convert each and every document into .pdf and keep it stored. This is how I keep my documents separated in different folders. Once made in such formatting, they are ready to take place in my electronic and real binders (active and archived)

Direct link Reply with quote
 

Louise Dupont  Identity Verified
Canada
Local time: 20:49
English to French
TOPIC STARTER
I found a way but.... May 4, 2004

The problem was that the date cell was in fact 2 cells combined and I could not change anything in it. I had to "unmerge" the cells. The first cell kept the current date format, and in the other one I was able to change the content and format. I swapped the cells around and merge them again. (When you merge 2 cells the program tells you that the attributes of the left cell will be applied to the new cell).
My software is in French and I don't know all the exact terms in the English version, I hope you can understand the steps I had to do.
Thanks to all!


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Excel changes date on invoice

Advanced search






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs