There is an extensive list of language ID’s available from Microsoft here. Where is the language ID for English, and dddd tells Excel to covert the date to the full name of the day. We use the TEXT Function to convert the dates by specifying the language ID in the format argument of the formula. Excel Dates Displayed in Different Languages This is for users who want to view their reports in a language that's different to their PC language settings. Note: if your users have their PC language set to their locale then you don't need to use this technique, because Excel will automatically convert date formats to their local language. It’d be a load of work to create a separate file for each language, so instead we can automate it like this: If you share Excel files and reports with users from different countries then you might want to give them a report in their language…and I don’t just mean converting from English to American 😉 Excel for Customer Service Professionals.
0 kommentar(er)
