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.

stringNormal@
stringUppercase@+
stringLowercase@-
NumberGeneral#.####
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$3U0
Currency$2.75U0.00
Currency2.75$0.00U
Currency$ 2.75U 0.00
Currency2.75 $0.00 U
Currency2.75 Unitef States Dollar0.00 UU
Currency2.75 USD0.00 UUU
Date10/3/1993{{M/d/yyyy}}
DateSunday, October 3, 1993{{dddd, MMMM d, yyyy}}
DateOctober 3, 1993{{MMMM d, yyyy}}
Date10/3/93{{M/d/yy}}
Date1993-10-03{{yyyy-MM-dd}}
Date3-Oct-93{{d-MMM-yy}}
Date10.3.1993{{M.d.yyyy}}
DateOct. 3, 93{{MMM. d, yy}}
Date3 October 1993{{d MMMM yyyy}}
DateOctober 93{{MMMM yy}}
DateOct-93{{MMM-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}}
Date17:00{{HH:mm}}
Date17:00:00{{HH:mm:ss}}

(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. https://docs.microsoft.com/en-us/office/vba/api/visio.visfieldformats )

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.

I hope this helps.

John… Visio MVP in x-aisle
JohnVisioMVP.ca

Published by johnvisiomvp

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s