Search results 168

Sorted from new to old.
Card image
InvertColor

Converts color into its negative value, as in "e4f15a" into "1C0FA6"

Card image
Hex2Dec

Converts hexadecimal strings into decimals

Card image
Dec2Hex

Converts integer decimals into Hexadecimals

Card image
Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

Card image
OpenPassword + ClosePassword

Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...

Card image
FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

Card image
FileDate_Formatted

Using FileDateTime to get file date

Card image
FindIn1DArray

Returns 1 if an item found in array, 0 if not

Card image
Time2Real

Converts TIME code to number HH:MM to xx.xx As in 10:15 to 10.25, 13:30 to 13.5

Card image
RGB2Long

Converts Red, Green and Blue integers into RGB long value

Card image
Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

Card image
StringFlip

Flips a string, right-to-left, and if passed again, will flip it back Can be ...

Card image
RoundUp

Rounds a number up, like Excel function RoundUP

Card image
DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

Card image
ANStrColor2RGB + RGB2ANStrColor

Converts R:G:B into RGB value (as long) and RGB from long into R:G:B

Card image
Hex2Bin

Converts Hex to Binary