Search results 189

Sorted from new to old.

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

CreditCardType

Returns credit card type and whether it is valid or not. Found it in my old ...

2023Jul28

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

NumberDigitImage

Creates list of images to represents a number. Basically multiple < img > tags ...

2023May15

NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

2023May3

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

JsBarcode

Generate barcode in js Tested and works better than others

2022Dec26

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

1 2 ...5 ...11 12