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: 09:35
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: 06:35
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: 15:35
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: 09:35
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: 12:35
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






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



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