Formatting Numbers: Difference between revisions
Jump to navigation
Jump to search
Created page with 'The best way to format numbers for output is to use the Format() function. It seems to work fine on either a string that looks like a number or just a regular number. Here is a …' |
No edit summary |
||
| Line 1: | Line 1: | ||
The best way to format numbers for output is to use the Format() function. It seems to work fine on either a string that looks like a number or just a regular number. | The best way to format numbers for output is to use the Format() function. Unlike the Str() function, Format does not add an extra space in front of positive numbers. It seems to work fine on either a string that looks like a number or just a regular number. # represents a number, 0 represents a required leading or trailing zero. | ||
Here is a simple use of Format() to show two decimal places: | Here is a simple use of Format() to show two decimal places: | ||
| Line 6: | Line 6: | ||
strText = "EL. " & Format(elev, "###0.00") | strText = "EL. " & Format(elev, "###0.00") | ||
EL. 1040.25 | EL. 1040.25 | ||
EL. 4.25 | |||
EL. 0.80 | |||
</PRE> | </PRE> | ||
| Line 11: | Line 13: | ||
<PRE> | <PRE> | ||
strText = "STA. " & Format(sta, "# | strText = "STA. " & Format(sta, "#0+00.00") | ||
STA. 35+52.00 | STA. 35+52.00 | ||
STA. 0+08.15 | |||
</PRE> | </PRE> | ||
Revision as of 18:27, 16 August 2010
The best way to format numbers for output is to use the Format() function. Unlike the Str() function, Format does not add an extra space in front of positive numbers. It seems to work fine on either a string that looks like a number or just a regular number. # represents a number, 0 represents a required leading or trailing zero.
Here is a simple use of Format() to show two decimal places:
strText = "EL. " & Format(elev, "###0.00") EL. 1040.25 EL. 4.25 EL. 0.80
Stationing in surveying puts a separator after the hundreds marker so you can generate the proper format with this statement:
strText = "STA. " & Format(sta, "#0+00.00") STA. 35+52.00 STA. 0+08.15