Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: joeKen
  • Content: Threads
  • Order by date
  1. joeKen

    Excel Text formatted cell gives up wrapping text half way through

    Hi, I have a spreadsheet with cells containing lots of text (500 to 1500 characters long). The cells are formatted as Text with Word text switched on. When Excel displays the text it wraps the text successfully of about the first half of the cell then then rest of the text disappears off in a...
  2. joeKen

    Setting Date Format from PC Settings

    Hi, I'm trying to convert a cell's date format to match that of the user. I have no idea what the user of the spreadsheet will wish to see, so I'm hoping to pick up the date format from there pc settings instead of hard coding "DD/MM/YYYY" or forcing them to select a date format from a combo...
  3. joeKen

    Converting Text to Date

    Hi, I have some data generated by another app. I'm writing a macro to convert my table data into a pivot table. However I've found the date information has come across as a text format. I tried changing the format to be a date format, but I think I need to clear out the data change the cell...
  4. joeKen

    JDE World EDI Solutions

    Hi, Does anyone have experience of EDI systems interfacing into JDE world software, system 47 files? I would be interested to know peoples thoughts of what works and what is currently being used. We currently use a third party package which, well let's just say, we wouldn't shed a tear if we...

Part and Inventory Search

Back
Top