Home | Products |Purchase | FAQ | Contact Us | Useful Resources

Excel-Tool Convert Excel Value

The software can convert Excel Dates to Weekday, Month, Quarter, Year, Day of year, Hour, Minute, Second; Convert Excel Case to Proper Case, Lower Case, Upper Case; Convert Excel Data Types to General or Text; Convert phone numbers to a uniform format, Phone Numbers format with brackets, dashes, slants, dots; Convert ZIP To City State ZIP; Convert ZIP To City, State ZIP; Convert ZIP To City State; Convert ZIP To City, State; Convert City State to City State ZIP; Convert City State to ZIP; Convert City to ZIP; Convert City, State to City, State ZIP; Convert City, State to ZIP. It worked smoothly and quickly, even with large worksheets, thereby saves your time. It is very simple to use.

With the software you may:

Convert Excel Dates to Weekday, Month, Quarter, Year, Day of year, Hour, Minute, Second.

Convert Excel Case to Proper Case, Lower Case, Upper Case.

Convert Excel Data Types to General or Text

Convert phone numbers to a uniform format.

Convert ZIP To City State ZIP; Convert City, State to ZIP; Convert City State to City State ZIP.

Current Version: 10.4.17
File Size: 1.84(MB)
Platform: Windows2000/XP/Vista/Windows7.
Software requirements: Microsoft Excel 97/2000/XP/2003/2007 or higher.
Purchase Price: $18.95

Convert Excel Dates to Weekday, Month, Quarter, Year, Day of year, Hour, Minute, Second

Taking a Date sheet for example: Convert Excel Dates to Weekday.

Select a range of cells.

For Office 2007. Open "Add-Ins" tab and menu "Convert > Convert Date to > Weekday"

For Office 2000/XP/2003. open menu "Convert > Convert Date to > Weekday"

Result is

How to insert a new column next to the original column?

Select a single column.

Open menu "Convert > Convert Date to > Weekday (Entire Column) "

Result is

Convert Excel Case to Proper Case, Lower Case, Upper Case.

Taking a case sheet for example: Convert Text to Proper Case.

Select a range of cells.

Open "Add-Ins" tab and menu "Convert > Convert Text Case to > Proper Case "

Result is

Convert Excel Data Types to General or Text

Taking a Data Types sheet for example: Convert Excel Data Types to Text.

Select a range of cells.

Open "Add-Ins" tab and menu "Convert > Convert Values to >Text"

Result is:

Convert phone numbers to a uniform format.

Taking a Phone Numbers sheet for example: Convert Phone Numbers to dashes format.

Select a range of cells.

Open "Add-Ins" tab and menu "Convert >Convert phone numbers to"

Result is:

Convert ZIP To City State ZIP; Convert City, State to ZIP; Convert City State to City State ZIP

Taking a sheet for example: Convert ZIP To City, State ZIP.

Select a range of cells.

Open "Add-Ins" tab and menu "Convert >Convert ZIP to > City, State ZIP "

Result is: