I have Macro's set up to run a bunch of data and combine some cells which will result in a number like 8-9. The issue I have is that the number will show as Aug-9 when I need it to say 8-9 because I reference that cell. I tried to format all of the cells to text number format in the spreadsheet then ran my Macro. This did not work because I use =A1&"-"&A2 to combine the cells and in formatting the cells as text it doesn't produce the number I need.
Are you looking for a "text" representation?
What about using:
=MONTH(A1)&"-"&DAY(A2)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
You'd be better off retaining the number as an Excel date and modifying the macros accordingly.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks