Mobile menu

How to write / in Excel?
Thread poster: Charlotte Blank
Charlotte Blank  Identity Verified
Local time: 20:50
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: 20:50
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: 13:50
French to Spanish
+ ...
Format > Cell > text Dec 9, 2004

That's all.
Luck.


Direct link Reply with quote
 
Charlotte Blank  Identity Verified
Local time: 20:50
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: 13:50
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






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 »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »



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