#number formatting

[fluk3sake]

Excel Using Custom Formats

Excel Using Custom Formats

Number Formatting is an Excel function many People use instinctually. Every time you right-click that cell in Excell and choose Format Cell to choose a Category under the Number Tab you are doing Number Formatting.

But not everybody really knows what this means. If you choose to change the number format from General to Number do you Actually change the Data? What happens if you change the…

View On WordPress

[fluk3sake]

Format Cells: Fraction

Formatting Cells is a way of changing the view of the Cell. All Cells by default is set as general with no specific format being assigned. Although as you would notice Excel tries and figures out the best format like Dates.

To Get to Number Formatting you can right-click on the specified Cell, Row or column and Choose Format Cells… alternatively press CTRL + 1

Fraction

The Fraction…

View On WordPress

[fluk3sake]

Excel Format Cells: Percentage

Excel Format Cells: Percentage

Formatting Cells is a way of changing the view of the Cell. All Cells by default is set as general with no specific format being assigned. Although as you would notice Excel tries and figures out the best format like Dates.

To Get to Number Formatting you can right-click on the specified Cell, Row or column and Choose Format Cells… alternatively press CTRL + 1

Percentage

The Percentage…

View On WordPress

[fluk3sake]

Excel Format Cells: Date vs Time

Excel Format Cells: Date vs Time

Formatting Cells is a way of changing the view of the Cell. All Cells by default is set as general with no specific format being assigned. Although as you would notice Excel tries and figures out the best format like Dates.

To Get to Number Formatting you can right-click on the specified Cell, Row or column and Choose Format Cells… alternatively press CTRL + 1

Date and Time Serialization

View On WordPress

[fluk3sake]

Excel Format Cells: Number

Excel Format Cells: Number

Formatting Cells is a way of changing the view of of the Cell. All Cells by default is set as general with no specific format being assigned. Although as you would notice Excel tries and figures out the best format like Dates.

To Get to Number Formatting you can right-click on the specified Cell, Row or column and Choose Format Cells… alternatively press CTRL + 1

Number

The Number…

View On WordPress

[marketingtech]

Formatting Telephone Numbers

Answering a Question From the Unica Campaign Forum: I would like to use a select process to ensure that all telephone numbers are 11 characters long, can anyone advise the best way to do this?

Create A Macro To Return The Value You Want:

Custom Macro:

Name: Get_10DigitPhone

Expression:

SELECT a.userid, REGEXP_REPLACE(a.phone, '[^0-9]+', '') FROM SCHEMA.TABLE a JOIN b ON a.userid= b.userid WHERE REGEXP_REPLACE(a.phone, '[^0-9]+', '') is not null AND LENGTH(REGEXP_REPLACE(a.phone, '[^0-9]+', ''))=10 --In your case you want 11

Expression Type: Raw SQL Selecting ID + Value

Database: Pick one

Value Type: Text or Number, ...whatever you need

Width: 10, 11, ...whatever you need

  You can then reference the macro in a derived field.

For large populations this may not be the best way to go about it, but I just tested this on a sample size of 3,000 and it worked out fine, ran in about 2 minutes.

[axel669]

Scientific Notation in AS3

The Number.toExponential function formats for scientific notation nicely, but it has errors when using more precision than the number requires

Ex: 1000000.129 -> 1.00000012899999 when using 14 as the argument.

So I wrote a function to format it the right way without the precision errors

public static function sciNotation(n:Number):String { var r:String=n.toString(); if(r.search('e')!=-1) return r; var sign:String=""; if(n1) return sign+x[0].charAt(0)+'.'+x[0].substr(1)+(x[1]||"")+'E+'+(x[0].length-1); var p:int=x[1].search(/[^0]/); return sign+x[1].charAt(p)+'.'+x[1].substr(p+1)+"E-"+(p+1); }