Skip to main content

Posts

Showing posts from 2009

Export Excel with formatting

The formatting you can use: mso-number-format:"0" No Decimals mso-number-format:"0\.00" 2 Decimals mso-number-format:"mm\/dd\/yy" Date format mso-number-format:"m\/d\/yy\ h\:mm\ AM\/PM" D -T AMPM mso-number-format:"Short Date" 05/06/-2008 mso-number-format:"Medium Date" 05-jan-2008 mso-number-format:"Short Time" 8:67 mso-number-format:"Medium Time" 8:67 am mso-number-format:"Long Time" 8:67:25:00 mso-number-format:"Percent" Percent - two decimals mso-number-format:"0\.E+00" Scientific Notation mso-number-format:"\@" Text mso-number-format:"\#\ ???\/???" Fractions - up to 3 digits (312/943) mso-number-format:"\0022£\0022\#\,\#\#0\.00" £12.76 mso-number-format:"\#\,\#\#0\.00_ \;\[Red\]\-\#\,\#\#0\.00\ " 2 decimals, negative numbers in red and signed (1.86 -1.66) mso-number-format:”\\#\\,\\#\\#0\\.00_\\)\\;\\[Black\\]\\\\(\\#\\,\\#\\#0\\.