Technical forums » Office applications »
Excel issue
Thread poster: Lamine Boukabour
Lamine Boukabour
Lamine Boukabour  Identity Verified
Algeria
Local time: 00:03
Member (2022)
English to Arabic
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
Portugal
Local time: 00:03
Danish to English
+ ...
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
Netherlands
Local time: 01:03
Member (2006)
English to 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
United Kingdom
Local time: 00:03
Member (2017)
German to English
+ ...
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
Algeria
Local time: 00:03
Member (2022)
English to Arabic
TOPIC STARTER
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:

Moderator(s) of this forum
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






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »