Combining Text and Buddhist Year Dates in Excel

silverswan747

This discussion is about how to combine text with Buddhist year format date in excel. It will cover how to convert the date format, how to add text to the date, and how to create a formula to combine the two. It will also discuss the various options available for customizing the date format.

Eevi515

You can combine text with Buddhist year format date in Excel by following the steps below:

Enter the date in cell A1.
Select cell A1 and navigate to the "Number" tab on the ribbon.
Select the "More Number Formats" option.
Choose the "Buddhist" option from the "Category" drop-down list.
Type the text you want to include in cell A2.
Type "& " in the formula bar and click on cell A1.
Type "& " in the formula bar and click on cell A2.
Press Enter to display the combined text with Buddhist year format date.

For further information and examples of usage, please refer to this Microsoft article:
https://support.microsoft.com/en-us/office/date-archives/1673e9d9-7ddb-43ef-8a13-5d1020a5a326

ian_hughes

There are a few steps you can take to combine text with Buddhist Year date format in Excel. Here’s what you need to do:

Select the cells that need to be converted.
Go to the ‘Home’ tab and select ‘Number’ from the ‘Number’ group.
In the drop-down menu, select ‘Date’ and then ‘ Buddhist Year’.
Enter the required text into the cells in the format =TEXT(cell, "text")
Once you have entered the text, select the cells again and click the ‘Format Cells’ option.
In the Format Cells window, go to the ‘Number’ tab and select ‘Text’ from the ‘Category’ menu.
Click ‘OK’ and your text will be combined with the Buddhist Year date format in the cells.

It is important to keep in mind that the text should be entered in the same cell as the Buddhist Year date format, in the correct order. you can find more details about formatting date in Excel here - https://support.microsoft.com/en-us/office/format-numbers-dates-and-times-3b3a43f9-f8ac-4ae5-81e5-af3daca84aa3 .
Good luck!