How to write / in Excel?
Thread poster: Charlotte Blank

Charlotte Blank  Identity Verified
Local time: 09:03
Czech to German
+ ...
Dec 9, 2004

Hi all,

this surely is an easy question but I don't seem to be able to find a solution. I just want to write 18/4 in Excel but it keeps on changing this into 18.04.2004 - how can I teach it to leave what I wrote? As far as I could see this is not covered by any help-file...

Thanks in advance for your help!

Charlotte

(Windows 98 SE, Excel 2002)


Direct link Reply with quote
 

Bob Kerns  Identity Verified
Germany
Local time: 09:03
Member (2002)
German to English
Type '18/4 Dec 9, 2004

Try entering '18/4

Direct link Reply with quote
 

Juan Jacob  Identity Verified
Mexico
Local time: 02:03
French to Spanish
+ ...
Format > Cell > text Dec 9, 2004

That's all.
Luck.


Direct link Reply with quote
 

Charlotte Blank  Identity Verified
Local time: 09:03
Czech to German
+ ...
TOPIC STARTER
Thanks!!! Dec 9, 2004

You saved me a lot of trouble

@ Bob: I tried that one before but as soon as I cleared the ' (or whatever else) the date re-appeared so unfortunately it was useless.

@ Juan: Your tip did the trick!

Charlotte


Direct link Reply with quote
 

Juan Jacob  Identity Verified
Mexico
Local time: 02:03
French to Spanish
+ ...
Anytime. Dec 9, 2004

Yes, sometimes tricky...
Luck.


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 »

How to write / in Excel?

Advanced search






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



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