Format Codes

Within Visio there are several data types and you can format data based on several Format codes.

Fixed List, Variable List amd Boolean do not have special Format codes. (or do they?)

The Formats for the various Data Types are:

With a little exploring I came up with the following table of data format codes.

NumberGeneral Units#.#### u
NumberWhole Number (3)0
NumberWhole Number with units (3 cm.)0 u
NumberFloating Point (2.75)0.00
NumberFloating Point with units (2.75 cm.)0.00 u
NumberFraction (2 3/4)# ##/##
NumberFraction with units (2 3/4 cm.)# ##/## u
DurationWeeks[w] ‘ew.’
DurationDays[d] ‘ed.’
DurationHours[h] ‘eh.’
DurationMinutes[m] ’em.’
DurationSeconds[s] ‘es.’
DurationHours and minutes (1:23)[h]:[mm]
DurationMinutes and seconds (0:12)[m]:[ss]
CurrencySystem Settings@
Currency$ 2.75U 0.00
Currency2.75 $0.00 U
Currency2.75 Unitef States Dollar0.00 UU
Currency2.75 USD0.00 UUU
DateSunday, October 3, 1993{{dddd, MMMM d, yyyy}}
DateOctober 3, 1993{{MMMM d, yyyy}}
DateOct. 3, 93{{MMM. d, yy}}
Date3 October 1993{{d MMMM yyyy}}
DateOctober 93{{MMMM yy}}
Date10/3/1993 5:00 PM{{M/d/yyyy h:mm am/pm}}
Date10/3/1993 5:00:00 PM{{M/d/yyyy h:mm:ss am/pm}}
Date5:00 PM{{h:mm am/pm}}
Date5:00:00 PM{{h:mm:ss am/pm}}

(Oct 1993 was just before the release of Visio 3)

The official Visio webpage describing the Format codes is here.

About Format Pictures | Microsoft Docs

( There is a note on that page mentioning predefined Formats. A list of those numbers appears to be here. )

As you may notice, that list is bit more extensive and I am in the process of making a webpage of a more complete set of examples. It is still early days and the webpage needs work. (I have yet to master table widths in WordPress. 😉 )

The webpage is Word Formats but it needs work. Eventually I will have a download on my download page that includes an Excel file of a more fuller list of Formats and a Visio document that includes examples (User cells) of how to use the codes, both the codes and the results. I will also expand the codes listed in the notes.

John… Visio MVP in x-aisle

Published by johnvisiomvp

The original Visio MVP. I have worked with the Visio team since 1993