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: 19:11
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: 17:11
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: 01:11
English to Turkish
+ ...
Start with single quote Jul 4, 2008

.... and that is an apostrophe.

 

Alejandra Hozikian
Argentina
Local time: 19:11
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: 23:11
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






Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



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