Technikai fórumok » Office applications »
Excel issue
Téma indítója: Lamine Boukabour
Lamine Boukabour
Lamine Boukabour  Identity Verified
Algéria
Local time: 22:15
Tag (2022 óta)
angol - arab
Dec 7, 2022

Hello,

In some excel cells, when I write: + Purchases, + Cash advances, or + Interest/Charges, some codes (something like "?NAME#") are shown instead of these writings. What steps do I follow to avoid this from happening?

Thanks!
 
Thomas T. Frost
Thomas T. Frost  Identity Verified
Portugália
Local time: 22:15
dán - angol
+ ...
Text format Dec 7, 2022

Excel thinks you are writing a formula when you begin with the + sign. Change the cell format to Text.

Lamine Boukabour
Philip Lees
 
Samuel Murray
Samuel Murray  Identity Verified
Hollandia
Local time: 23:15
Tag (2006 óta)
angol - afrikaans
+ ...
Apostrophe Dec 7, 2022

Lamine Boukabour wrote:
In some excel cells, when I write: + Purchases, + Cash advances, or + Interest/Charges, some codes (something like "?NAME#") are shown instead of these writings.

Try writing an apostrophe ' as the first character of the text.

Steve Robbie
Lamine Boukabour
John Fossey
 
Steve Robbie
Steve Robbie
Egyesült Királyság
Local time: 22:15
Tag (2017 óta)
német - angol
+ ...
Alternatively Dec 7, 2022

Alternatively, enter an apostrophe before the + : '+Purchases

The cell will display +Purchases, but not the apostrophe.

Lamine Boukabour
 
Lamine Boukabour
Lamine Boukabour  Identity Verified
Algéria
Local time: 22:15
Tag (2022 óta)
angol - arab
TÉMAINDÍTÓ
Thank you all Dec 7, 2022

Steve Robbie, Thomas T. Frost, and Samuel Murray thank you for the valuable input!
 


To report site rules violations or get help, contact a site moderator:

A fórum moderátora(i)
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

You can also contact site staff by submitting a support request »

Excel issue






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 Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »