Mobile menu

How to write / in Excel?
Thread poster: Charlotte Blank
Charlotte Blank  Identity Verified
Local time: 14: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: 14: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: 07: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: 14: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: 07: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






memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »



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