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

Charlotte Blank  Identity Verified
Local time: 18:28
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)


 

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

Try entering '18/4

 

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

That's all.
Luck.


 

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

You saved me a lot of troubleicon_smile.gif

@ 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


 

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

Yes, sometimes tricky...
Luck.


 


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






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

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

More info »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »



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