the final column looks like this =IF(ROUND(((H2-ROUNDDOWN(H2,0))*12),0)>11,(ROUNDDOWN(H2,0)+1&"-"&0),(ROUNDDOWN(H2,0)&"-"&ROUND(((H2-ROUNDDOWN(H2,0))*12),0))) That data is then pulled into the following worksheet with the proper format/structure necessary for the excel...
What I have works-- but the file is absolutely massive and SLOW. I don't know how to more efficiently format it. I don't see away to attach my file... hopefully I can do so after I've posted. The current structure goes like this. ...
ControlFormat Corners CubeField CubeFields CustomProperties CustomProperty CustomView CustomViews Databar DataBarBorder DataFeedConnection DataLabel DataLabels DataTable DefaultWebOptions Diagram DiagramNode DiagramNodeChildren DiagramNodes Dialog DialogFrame Dialogs DialogSheet DialogSheets DialogSheetView DisplayFormat...
ExcelWorksheetView ExceptionInternal ExceptionPrivate ExceptionProtected ExceptionPublic ExceptionSealed ExceptionSettings ExceptionShortcut ExclamationPoint ExclamationPointNoColor ExcludeMember ExcludeMemberFormula ExcludePath ExcludeRun ExecutableType Execute ExecuteDDL ExistingConnection ExistingConnectionFormat ExistsInCollect...
ControlFormat Corners CubeField CubeFields CustomProperties CustomProperty CustomView CustomViews Databar DataBarBorder DataFeedConnection DataLabel DataLabels DataTable DefaultWebOptions Diagram DiagramNode DiagramNodeChildren DiagramNodes Dialog DialogFrame Dialogs DialogSheet DialogSheets DialogSheetView...
_Worksheet AboveAverage Action Actions AddIn AddIns AddIns2 Adjustments AllowEditRange AllowEditRanges AppEvents AppEvents_AfterCalculateEventHandler AppEvents_Event AppEvents_NewWorkbookEventHandler AppEvents_ProtectedViewWindowActivateEventHandler AppEvents_ProtectedViewWindowBeforeCloseEventHandler Ap...
ControlFormat Corners CubeField CubeFields CustomProperties CustomProperty CustomView CustomViews Databar DataBarBorder DataFeedConnection DataLabel DataLabels DataTable DefaultWebOptions Diagram DiagramNode DiagramNodeChildren DiagramNodes Dialog DialogFrame Dialogs DialogSheet DialogSheets DialogSheetView DisplayFormat...
ExcelWorksheetView ExceptionInternal ExceptionPrivate ExceptionProtected ExceptionPublic ExceptionSealed ExceptionSettings ExceptionShortcut ExclamationPoint ExclamationPointNoColor ExcludeMember ExcludeMemberFormula ExcludePath ExcludeRun ExecutableType Execute ExecuteDDL ExistingConnection ExistingConnectionFormat ExistsInCollect...
1. Click Start | Settings | Control Panel | Regional Settings. 2. Compare the Regional Settings Properties on a workstation that does not receive the error to the settings on the workstation that is receiving the error. 3. If the settings are different, change the ...
1. Click Start | Settings | Control Panel | Regional Settings. 2. Compare the Regional Settings Properties on a workstation that does not receive the error to the settings on the workstation that is receiving the error. 3. If the settings are different, change the ...