Mobile menu

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

That's all.
Luck.


Direct link Reply with quote
 
Charlotte Blank  Identity Verified
Local time: 10:07
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: 03:07
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






LSP.expert
You’re a freelance translator? LSP.expert helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

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