Set the date column to "Date" format before translation
Use the "Text to Columns" feature to restore the date format after translation
Problem 3: Spaces before and after numbers
Reason: Extra spaces introduced during the translation process
Solution:
Use the TRIM() function to remove extra spaces
Or use "Find and Replace" to batch delete spaces
Problem 4: Table layout is messed up
Reason: Text length changes after translation
Solution:
Use the "AutoFit Column Width" feature
Manually adjust the width of key columnsConsider using text wrapping
Problem 5: Chart labels not translated
Reason: Chart labels are independent objects and need to be handled separately
Solution:
Use tools that support chart translation
Or manually edit chart labels
Advanced tips for Excel translation
1. Use a glossary to ensure consistency
For Excel tables containing a large number of technical terms:
Create a glossary to define standard translations for keywords
LANDUD supports importing custom glossaries
Ensure consistency of term translation throughout the table
2. Batch translate multiple worksheets
If the Excel file contains multiple worksheets:
LANDUD automatically identifies all worksheets
Translate the entire workbook at once
Maintain reference relationships between worksheets
3. Handle Excel files containing macros
For Excel files containing VBA macros:
Export macro code backup before translation
Re-import macros after translation
Test whether macro functions are working properly
4. Bilingual comparison table
If you need to keep both the original text and the translated text: