Home | Quick Start | Documentation | Download | Support | Contribute

# Conversion Functions In AFC

### Conversion Functions

The supported conversion functions are shown by example below:

##### VALUE (does not support blanks!)
 A B C 2 123.0 =VALUE( C2 ) 123 3 123.0 ... 123 4 123.55 ... 123.55 5 -23.0 ... -23 6 1.0E8 ... 100,000,000 7 0.2 ... 20% 8 1.234567E9 ... 1,234.567e6 9 -1.2345E-6 ... -12345e-10 10 -1.23456E-7 ... -123,456E-12 11 12.345 ... 12.345 12 35981.0 ... 7/5/1998 13 35981.0 ... 7/5/98 14 35981.50902777778 ... 7/5/1998 12:13 15 35981.50918981482 ... 7/5/98 12:13:14 16 0.5090277777777777 ... 12:13 17 0.5091898148148148 ... 12:13:14 18 0.009027777777777779 ... 0:13 19 0.009189814814814814 ... 0:13:14 20 35981.50902777778 ... 7/5/1998 12:13 PM 21 35981.50918981482 ... 7/5/98 12:13:14 PM 22 0.5090277777777777 ... 12:13 PM 23 0.5091898148148148 ... 12:13:14 PM 24 0.5090277777777777 ... 0:13 PM 25 0.5091898148148148 ... 0:13:14 PM 26 0.009027777777777779 ... 12:13 AM 27 0.009189814814814814 ... 12:13:14 AM 28 0.009027777777777779 ... 0:13 AM 29 0.009189814814814814 ... 0:13:14 AM 30 10959.0 ... 1/1/30 31 47483.0 ... 12/31/29 32 35981.0 ... 1998/7/5 33 35981.50902777778 ... 1998/7/5 12:13 34 35981.50918981482 ... 1998/7/5 12:13:14 35 35981.0 ... 1998-7-5 36 35981.50902777778 ... 1998-7-5 12:13 37 35981.50918981482 ... 1998-7-5 12:13:14 38 !FE ... This is not a number Excel says: #VALUE!

##### N (does not support blanks!)
 A B C 40 12.345 =N( C40 ) 12.345 41 0.0 ... 12345 42 39083.0 ... 39083.0 43 0.0 ... 1/1/2007 44 1.0 ... true 45 0.0 ... false

##### T (does not support blanks!)
 A B C 47 AaBbCcDd =T( C47 ) AaBbCcDd 48 АаБбВвГгДд ... АаБбВвГгДд 49 ... 123.45 50 123.45 ... 123.45 51 ... 39083.0 52 1/1/2007 ... 1/1/2007 53 ... true 54 ... false

##### TEXT (does not support blanks!)
 A B C D 56 0 =TEXT( C56, D56 ) 0.0 @ 57 99999999999 ... 9.99999999994999E10 @ 58 1E+11 ... 9.99999999995E10 @ 59 0.000000009 ... 9.0E-9 @ 60 9E-09 ... 9.000001E-9 @ 61 7.77778E-05 ... 7.77777777777777E-5 @ 62 0.000777778 ... 7.77777777777777E-4 @ 63 0.007777778 ... 0.00777777777777777 @ 64 0.077777778 ... 0.0777777777777777 @ 65 0.777777778 ... 0.777777777777777 @ 66 7.777777778 ... 7.77777777777777 @ 67 77.77777778 ... 77.7777777777777 @ 68 777.7777778 ... 777.777777777777 @ 69 7777.777778 ... 7777.77777777777 @ 70 77777.77778 ... 77777.7777777777 @ 71 777777.7778 ... 777777.777777777 @ 72 7777777.778 ... 7777777.77777777 @ 73 77777777.78 ... 7.77777777777777E7 @ 74 777777777.8 ... 7.77777777777777E8 @ 75 7777777778 ... 7.77777777777777E9 @ 76 77777777778 ... 7.77777777777777E10 @ 77 7.77778E+11 ... 7.77777777777777E11 @ 78 7.77778E+12 ... 7.77777777777777E12 @ 79 7.77778E+13 ... 7.77777777777777E13 @ 80 7.77778E+14 ... 7.77777777777777E14 @ 81 -777777777.8 ... -7.77777777777777E8 @ 82 -7777777778 ... -7.77777777777777E9 @ 83 -77777777778 ... -7.77777777777777E10 @ 84 -7.77778E+11 ... -7.77777777777777E11 @ 85 0.000000001 ... 1.0E-9 @ 86 0.000000011 ... 1.1E-8 @ 87 0.000000111 ... 1.11E-7 @ 88 0.000001111 ... 1.111E-6 @ 89 0.000011111 ... 1.1111E-5 @ 90 0.000111111 ... 1.11111E-4 @ 91 0.001111111 ... 0.001111111 @ 92 0.011111111 ... 0.011111111 @ 93 0.111111111 ... 0.111111111 @ 94 1E-11 ... 1.0E-11 @ 95 1.1E-10 ... 1.1E-10 @ 96 1.01E-09 ... 1.01E-9 @ 97 1.101E-08 ... 1.101E-8 @ 98 1.1101E-07 ... 1.1101E-7 @ 99 1.11101E-06 ... 1.11101E-6 @ 100 1.1111E-05 ... 1.111101E-5 @ 101 0.000111111 ... 1.1111101E-4 @ 102 0.001111111 ... 0.00111111101 @ 103 0.011111111 ... 0.01111111101 @ 104 0.111111111 ... 0.11111111101 @ 105 9.9E-10 ... 9.9E-10 @ 106 1.99E-09 ... 1.99E-9 @ 107 1.199E-08 ... 1.199E-8 @ 108 1.1199E-07 ... 1.1199E-7 @ 109 1.11199E-06 ... 1.11199E-6 @ 110 1.1112E-05 ... 1.111199E-5 @ 111 0.000111112 ... 1.1111199E-4 @ 112 0.001111112 ... 0.00111111199 @ 113 0.011111112 ... 0.01111111199 @ 114 0.111111112 ... 0.11111111199 @ 115 AaBbCcDd ... AaBbCcDd @ 116 АаБбВвГгДд ... АаБбВвГгДд @

##### FIXED
 A B C D E 118 123.00 =FIXED( C118 ) 123.0 119 12.340 =FIXED( C119, D119 ) 12.34 3.0 120 12,345.340 ... 12345.34 3.0 121 123,456,789.123 ... 1.23456789123456E8 3.0 122 12,300 ... 12345.34 -2.0 123 12345.340 =FIXED( C123, D123, E123 ) 12345.34 3.0 true 124 12,345.340 ... 12345.34 3.0 false 125 1,234,567,891,234.56 ... 1.23456789123456E12 2.0 false 126 123,456,789,123,400.00 ... 1.234567891234E14 2.0 false 127 1,234.6 =FIXED( C127, D127 ) 1234.567 1.0 128 -1,230 ... -1234.567 -1.0 129 1230 =FIXED( C129, D129, E129 ) 1234.567 -1.0 true 130 -1230 ... -1234.567 -1.0 true

##### DOLLAR
 A B C D 132 \$123.00 =DOLLAR( C132 ) 123.0 133 (\$1,234.57) ... -1234.567 135 (\$1,000) =DOLLAR( C135, D135 ) -1234.5678 -3.0 136 (\$1,234.568) ... -1234.5678 3.0

##### CHAR
 A B C 138 A =CHAR( C138 ) 65.0 139 8 ... 56.0 140 { ... 123.0 141 } ... 125.0 142 d ... 100.0 143  ... 127.0 144 ¬ ... 172.0 145 !FE ... 0.0 Excel says: #VALUE! 146 !FE ... 256.0 Excel says: #VALUE! 147 !FE ... 1200.0 Excel says: #VALUE! 148 !FE ... 2050.0 Excel says: #VALUE! 149 !FE ... -1.0 Excel says: #VALUE!

##### CODE
 A B C 151 65.0 =CODE( C151 ) A 152 97.0 ... a 153 97.0 ... aA 154 49.0 ... 1.0 155 49.0 ... 12.0 156 127.0 ...  157 104.0 ... h 158 63.0 ... ё 159 246.0 ... ö

##### DATEVALUE
 A B C 161 35981.0 =DATEVALUE( C161 ) 7/5/1998 162 35981.0 ... 7/5/98 163 35981.0 ... 7/5/1998 12:13 164 35981.0 ... 7/5/98 12:13:14 165 0.0 ... 12:13 166 0.0 ... 12:13:14 167 35981.0 ... 7/5/1998 12:13 PM 168 35981.0 ... 7/5/98 12:13:14 PM 169 10959.0 ... 1/1/30 170 47483.0 ... 12/31/29 171 35981.0 ... 1998/7/5 172 35981.0 ... 1998/7/5 12:13 173 35981.0 ... 1998/7/5 12:13:14 174 35981.0 ... 1998-7-5 175 35981.0 ... 1998-7-5 12:13 176 35981.0 ... 1998-7-5 12:13:14 177 39106.0 ... 1/24/2007 178 39106.0 ... 1/24/07 179 !FE ... 1-7-4 Excel says: 37993.0 180 !FE ... 01-07-04 Excel says: 37993.0 181 !FE ... 01-07-2004 Excel says: 37993.0 182 37993.0 ... 01/07/2004 183 !FE ... 01 07 2004 Excel says: #VALUE! 184 37076.0 ... 2001/7/4 185 37076.0 ... 2001-7-4 186 37076.0 ... 2001-07-04 187 !FE ... 6/6/1996 12:00:00 AM Excel says: 35222.0 188 !FE ... January 24, 2007 Excel says: 39106.0 189 !FE ... Jan 24, 2007 Excel says: 39106.0 190 !FE ... Jan 24, 07 Excel says: 39106.0 191 !FE ... Jan , 24, 07 Excel says: 39106.0 192 !FE ... Jan 24,07 Excel says: #VALUE! 193 !FE ... Jan - 24, 07 Excel says: 39106.0 194 !FE ... 09-AUG 2008 Excel says: 39669.0 195 !FE ... Jan 24 Excel says: 39106.0 196 !FE ... 24 Jan Excel says: 39106.0 197 !FE ... 24 Jan 12: 13:14 Excel says: 39106.0 198 !FE ... AUG-10 Excel says: 39304.0 199 !FE ... AUG 10 Excel says: 39304.0 200 !FE ... 10-AUG Excel says: 39304.0 201 !FE ... 10 - AUG-07 Excel says: 39304.0 202 !FE ... AUGUST 06 Excel says: 39300.0 203 !FE ... AUGUST 2006 Excel says: 38930.0 204 !FE ... FEB 30 Excel says: 10990.0 205 !FE ... 09-AUGUST-2008 Excel says: 39669.0 206 !FE ... 09/AUGUST-2008 Excel says: 39669.0 207 !FE ... 09 AUGUST 2008 Excel says: 39669.0 208 !FE ... January 24 Excel says: 39106.0 209 !FE ... 2007 Excel says: #VALUE! 210 !FE ... 37/1 Excel says: #VALUE! 211 !FE ... 1-37 Excel says: 13516.0 212 !FE ... 1/37 Excel says: 13516.0 213 !FE ... 1/1937 Excel says: 13516.0 214 !FE ... 1/8 Excel says: 39090.0 215 39145 ... 2/32/2007 Excel says: #VALUE! 216 !FE ... 1/2008 Excel says: 39448.0 217 39090.0 ... 1/8/2007 218 !FE ... 09 AUGUST, 2008 Excel says: #VALUE! 219 !FE ... 2009 AUGUST 08 Excel says: #VALUE! 220 !FE ... AUGUST 08 2009 Excel says: #VALUE! 221 !FE ... 2009 08 AUG Excel says: #VALUE! 222 !FE ... 08.10.97 Excel says: #VALUE! 223 !FE ... 01.10.01 Excel says: #VALUE! 224 35981 ... 7/5/98 12:21:1f Excel says: #VALUE! 225 !FE ... 08.10.1997 Excel says: #VALUE!

##### TIMEVALUE
 A B C 227 0.5090277777781012 =TIMEVALUE( C227 ) 7/5/1998 12: 13 228 0.5091898148166365 ... 7/5/98 12:13:14 229 0.0 ... 7/5/1998 230 0.5090277777777777 ... 12:13 231 0.5091898148148148 ... 12:13:14 232 0.009027777777777779 ... 0:13 233 0.009189814814814814 ... 0:13:14 234 0.5090277777781012 ... 7/5/1998 12:13 PM 235 0.5091898148166365 ... 7/5/98 12:13:14 PM 236 0.5090277777777777 ... 12:13 PM 237 0.5091898148148148 ... 12:13:14 PM 238 0.5090277777777777 ... 0:13 PM 239 0.5091898148148148 ... 0:13:14 PM 240 0.009027777777777779 ... 12:13 AM 241 0.009189814814814814 ... 12:13:14 AM 242 0.009027777777777779 ... 0:13 AM 243 0.009189814814814814 ... 0:13:14 AM 244 0.0 ... 6/6/1996 12:00:00 AM 245 0.5090277777781012 ... 1998/7/5 12:13 246 0.5091898148166365 ... 1998/7/5 12:13:14 247 0.5090277777781012 ... 1998-7-5 12:13 248 0.5091898148166365 ... 1998-7-5 12:13:14 249 0.050694444444444375 ... 49:13

##### ROMAN
 A B C D 2 I =ROMAN( C2 ) 1.0 3 II ... 2.2 4 XII ... 12.0 5 IX ... 9.0 6 XI ... 11.0 7 XL ... 40.0 8 XLIX ... 49.0 9 XCIX ... 99.0 10 C ... 100.0 11 CLIX ... 159.0 12 MCXXIII ... 1123.0 13 MMMCMXCIX ... 3999.0 14 CDXCIX ... 499.0 15 CDXCIX =ROMAN( C15, D15 ) 499.0 0.0 16 LDVLIV ... 499.0 1.0 17 XDIX ... 499.0 2.0 18 VDIV ... 499.0 3.0 19 ID ... 499.0 4.0 20 MMXIII ... 2013.0 0.0 21 !FE =ROMAN( C21 ) 4000.0 Excel says: #VALUE!