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: 16:43
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: 14:43
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: 22:43
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: 16:43
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: 20:43
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






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »
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 »



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