- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Need Excel help asap
Posted on 2/28/23 at 9:57 am
Posted on 2/28/23 at 9:57 am
I have a spreadsheet that's due today and I can't get it to work correctly.
I have a string of birthdays, but I need them in mmddyyyy format.
I need to keep the 0 in the birthdays that are in the single digit months (like 04181998) but I also need to upload in a csv file.
When I change to csv format the leading zeros are dropped.
I have tried a few tricks from the google, but no luck.
I have a string of birthdays, but I need them in mmddyyyy format.
I need to keep the 0 in the birthdays that are in the single digit months (like 04181998) but I also need to upload in a csv file.
When I change to csv format the leading zeros are dropped.
I have tried a few tricks from the google, but no luck.
3
Posted on 2/28/23 at 10:13 am to Sir Drinksalot
If nobody answers, you have two options to do this quickly.
Fivver (website)
Chat GPT
Fivver (website)
Chat GPT
Posted on 2/28/23 at 10:18 am to Sir Drinksalot
Try the below.
A1 is a date.
=TEXT(A1,"mm")&TEXT(A1,"dd")&TEXT(A1,"yyyy")
A1 is a date.
=TEXT(A1,"mm")&TEXT(A1,"dd")&TEXT(A1,"yyyy")
Posted on 2/28/23 at 10:19 am to Sir Drinksalot
In cell next to the date =TEXT(datecell,"MMDDYYYY")
Posted on 2/28/23 at 10:20 am to dtett
You can string it all together without using the & concatenation.
Where do we send the bill?
Where do we send the bill?
Posted on 2/28/23 at 10:21 am to WhiskeyThrottle
I like to make my formulas as complicated as possible in order to bog down my computer.
Posted on 2/28/23 at 10:23 am to WhiskeyThrottle
I am very thankful for the tech board help 
Posted on 2/28/23 at 10:24 am to dtett
quote:
I like to make my formulas as complicated as possible in order to bog down my computer.
Oh good point. Your way is better for accomplishing that.
I'm in development now, but we have to run ad-hoc queries and drop it in excel for end users frequently and seeing what they come up with is very interesting. I had about 10 years of the "end user" excel learning curve before I entered IT so I get where they are. But I still enjoy jacking around with excel at times.
Posted on 2/28/23 at 10:40 am to WhiskeyThrottle
In my defense, the text function has a lot of hidden features that aren't immediately clear unless you've found a need to use said feature.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News