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: 01:07
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!


 

Yaotl Altan  Identity Verified
Mexico
Local time: 23:07
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.

 

Faruk Atabeyli  Identity Verified
Turkey
Local time: 07:07
English to Turkish
+ ...
Start with single quote Jul 4, 2008

.... and that is an apostrophe.

 

Alejandra Hozikian
Argentina
Local time: 01:07
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.

 

madak  Identity Verified
United Kingdom
Local time: 05:07
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).

 


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






PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

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



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