- 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
Excel Help - making a date not a raw number
Posted on 4/26/16 at 3:34 pm
Posted on 4/26/16 at 3:34 pm
So I'm trying run some XML conversations using a schema. When I try to export, everything comes out except the column where I have the date I need keeps getting input to the XML file as a raw number. Example, 5/11/16 comes out as 42508.
How can I convert a column full of dates to where the cell data is actually " '5/11/16" ? I find that when I put the apostrophe in there it turns it into "text" which is the date itself.
TL;DR, How can I combine two columns of data that have a date and an apostrophe to convert the date into "text" to use in an xml conversion?
How can I convert a column full of dates to where the cell data is actually " '5/11/16" ? I find that when I put the apostrophe in there it turns it into "text" which is the date itself.
TL;DR, How can I combine two columns of data that have a date and an apostrophe to convert the date into "text" to use in an xml conversion?
2
Posted on 4/26/16 at 3:41 pm to Brettesaurus Rex
Try =TEXT(A32,"m/d/yyyy")
Posted on 4/27/16 at 6:29 am to CubsFanBudMan
That did it! Thanks 
Posted on 4/27/16 at 8:31 am to Brettesaurus Rex
Why not just change the formatting of the column?
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News