Forum Discussion
Heading is converted to date when all i wanted was [1-10] representing days overdue
hi, i copied the result set of an account receivable "aging" query run in ssms over to excel. Column heading might be something like Current, [1-10] ,[11-30],[31-60]...[>=181] representing the $'s o...
It sounds like Excel is automatically interpreting the headings [1-10] and [11-30] as dates due to their format. To prevent Excel from converting them to dates, you can precede the headings with an apostrophe ', which tells Excel to treat the content as text.
Here's what you can do:
- Insert Apostrophe:
- Click on the cell containing the heading [1-10].
- In the formula bar or directly in the cell, type ' (apostrophe) before [1-10].
- Repeat the same for [11-30] and any other headings that Excel is converting to dates.
- Format as Text:
- After inserting the apostrophe, Excel should treat the content as text.
- You can format the cell to remove the apostrophe and any leading spaces if desired.
By preceding the headings with an apostrophe, Excel will recognize them as text and won't attempt to convert them to dates. This should resolve the issue of nonsensical dates appearing in your column headings.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.