Mobile menu

How to insert a number in an excel cell when it appears a formula in tools bar?
Thread poster: Alejandra Hozikian

Alejandra Hozikian
Argentina
Local time: 23:47
Member (2004)
English to Spanish
+ ...
Jul 4, 2008

I have to add a number in the cells of the excel spreadsheet but when I try there appears a formula in the tools bar. However I am supposed to add that number which can certainly affect the final result.

I do also have to change period for commas in excel cells and the same happens, there is a formula in the tools bar.
Thank you for your help!


Direct link Reply with quote
 

Yaotl Altan  Identity Verified
Mexico
Local time: 20:47
Member (2006)
English to Spanish
+ ...
Apostroph Jul 4, 2008

I think you have to use an apostroph so Excel understands it as a text input instead of a numeric one.

Direct link Reply with quote
 

Faruk Atabeyli  Identity Verified
Turkey
Local time: 05:47
Member (2009)
English to Turkish
+ ...
Start with single quote Jul 4, 2008

.... and that is an apostrophe.

Direct link Reply with quote
 

Alejandra Hozikian
Argentina
Local time: 23:47
Member (2004)
English to Spanish
+ ...
TOPIC STARTER
How to edit numbers in excel Jul 4, 2008

Thank you, Yaotl and Myriam!! I was able to solve it.

Direct link Reply with quote
 

Madeleine MacRae Klintebo  Identity Verified
United Kingdom
Local time: 03:47
Swedish to English
+ ...
Format the cell/s as text Jul 4, 2008

That also solves the problem of you entering "1.20" and excel changing it to "1.2" (unless you define that you want 2 decimals).

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 insert a number in an excel cell when it appears a formula in tools bar?

Advanced search






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »



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