https://tha.proz.com/forum/office_applications/360091-excel_issue.html
This site uses cookies. Some of these cookies are essential to the operation of the site, while others help to improve your experience by providing insights into how the site is being used. For more information, please see the ProZ.com privacy policy.
Cookie settings

ฟอรัมเทคนิค » Office applications »
Excel issue
เธรดต่อผู้เขียนข้อความ: Lamine Boukabour
Lamine Boukabour
Lamine Boukabour  Identity Verified
แอลจีเรีย
Local time: 03:50
สมาชิก (2022)
ภาษาอังกฤษ เป็น ภาษาอาหรับ
+ ...
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
โปรตุเกส
Local time: 03:50
ภาษาแดนิช เป็น ภาษาอังกฤษ
+ ...
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
เนเธอร์แลนด์
Local time: 04:50
สมาชิก (2006)
ภาษาอังกฤษ เป็น ภาษาอาฟริกา
+ ...
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
สหราชอาณาจักร
Local time: 03:50
สมาชิก (2017)
ภาษาเยอรมัน เป็น ภาษาอังกฤษ
+ ...
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
แอลจีเรีย
Local time: 03:50
สมาชิก (2022)
ภาษาอังกฤษ เป็น ภาษาอาหรับ
+ ...
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:

ผู้ไกล่เกลี่ยของฟอรัมนี้
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


Forum rules
Help and orientation




Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »