Formatting for just decimal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to get a number to display just the decimal portion? That
is, I do not want 0.03 but .03? Thanks
 
I tried this from the Immediate window, does it help?

?Format(0.22, ".##")
..22
 
Is there any way to get a number to display just the decimal portion? That
is, I do not want 0.03 but .03? Thanks
Click to expand...

Set the format of the control to:
#.00
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
format 9
Number format in listbox 1
Decimal places in forms 2
Pivot table view does not show series data with decimals? 0
formula for decimal point 4
Using Numbers and decimals 7
Excel Stop Excel from displaying rounded values 4

Back
Top