Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
Regular business hours will resume on Monday, October 5, 2026.
Created:
Jul 19, 2022 07:00 AM
| Last Modified: Jun 10, 2023 4:51 PM(1809 views)
Is the anyway to reassign which figures are date and month - 07/05/2022 10:24:21. The column is formatted D/M/Y h:m:s but the date is actually 05th of July.
Messed up 1 data sheet in Excel and concatenating to ones that are correct - please help!
If you have already "messed up" as in the data is wrong, you could maybe try method used hereDate Conversion issue . First change the column to character column -> back to numeric -> change to correct format/use format pattern to fix the data.
If you have already "messed up" as in the data is wrong, you could maybe try method used hereDate Conversion issue . First change the column to character column -> back to numeric -> change to correct format/use format pattern to fix the data.
