data format change

  1. P

    Unifi two date formats where one is DATE and the other is TEXT

    Hello everyone, I've got data set which has two date formats where one is DATE and the other is TEXT. Ideally I would like VBA to convert TEXT to date. I appreciate any helpful tips! Sample format is as follows: Shorter one is DATE, longer with timestamp is TEXT. Ideal ouput is eg. 11/01/2016...
  2. S

    List need to arramge

    Hi I have a list of data which i Got from pivot table which is given below and i want those data in different format. Please help Place Name USA John Rohan Alex Roxy India Rahim Sourav Bikram I want previous...
  3. T

    Data Formatting

    Hello Everyone! I'm having a bit of trouble with formatting a fairly large data set. Currently, there are ~10,000 rows of data. Each row has the following information format in it: <tbody> A B C D E F G H I J K TEXT DATE DATE TEXT GENERAL (INCLUDES NUMBERS) TEXT CURRENCY TEXT (INCLUDES...
  4. K

    Need Vba macro to convert data

    <tbody> Date Department Time Seconds Frequency 01-Sep HR 0900-1100 30 2 01-Sep HR 0900-1100 60 2 01-Sep SALES 1900-2100 30 3 01-Sep SALES 1900-2100 60 4 01-Sep ADMIN 2200-2300 30 2 01-Sep ADMIN 2300-2400 60 3 02-Sep HR 0900-1100 30 2 02-Sep HR 0900-1100 60 1 02-Sep SALES...
  5. Z

    Data Format Chage

    Hello Guys! My requirements are as under:- <tbody style="border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased;"> Current Data Form CustCode ItemCode 101 400001 102 400002 103 400003 104 400004 105 400005 </tbody> <tbody style="border...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top