Only 2 decimals

  • Thread starter Thread starter alvin Kuiper
  • Start date Start date
A

alvin Kuiper

Hi

I want a ciffer with only 2 dcimals but with out separator and so on
So formatnumber and formatcurrency dosn't work here.

Alvin
 
What's a ciffer? You could use formatnumber or formatcurrency as long as
you provide the arguments to specify two decimal places (assuming it is not
in your regional settings already as two decimal places), eliminate the
separator and so on, but the format function may be a more direct approach
if you are working with values that already are numbers.
 
What's a ciffer? You could use formatnumber or formatcurrency as long as
you provide the arguments to specify two decimal places (assuming it is not
in your regional settings already as two decimal places), eliminate the
separator and so on, but the format function may be a more direct approach
if you are working with values that already are numbers.
 
If you mean you want to display 100.0179 as 10001. I don't believe you
can do that. If you want you can change the number by multiplying by
100 and then either using the format function or truncating or rounding
to zero places

Given that x = 100.0179

Int(x *100) = 10001
Round(x*100,0)=10002

Format(X*100,"#,###") =10,002

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
If you mean you want to display 100.0179 as 10001. I don't believe you
can do that. If you want you can change the number by multiplying by
100 and then either using the format function or truncating or rounding
to zero places

Given that x = 100.0179

Int(x *100) = 10001
Round(x*100,0)=10002

Format(X*100,"#,###") =10,002

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
I seem to have understood the question, to the extent it was understandable
at all, differently than you did. I took the question to mean the OP wanted
1001.25 rather than 1,001.251.
 
I seem to have understood the question, to the extent it was understandable
at all, differently than you did. I took the question to mean the OP wanted
1001.25 rather than 1,001.251.
 
Well, I was only guessing at what the poster wanted. Perhaps the poster
needs to give us a couple of examples of the original data and the
desired output. With that a more definitive answer should be possible.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Well, I was only guessing at what the poster wanted. Perhaps the poster
needs to give us a couple of examples of the original data and the
desired output. With that a more definitive answer should be possible.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
It was rather enigmatic, wasn't it?

John Spencer said:
Well, I was only guessing at what the poster wanted. Perhaps the poster
needs to give us a couple of examples of the original data and the desired
output. With that a more definitive answer should be possible.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
Click to expand...
 
It was rather enigmatic, wasn't it?

John Spencer said:
Well, I was only guessing at what the poster wanted. Perhaps the poster
needs to give us a couple of examples of the original data and the desired
output. With that a more definitive answer should be possible.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
Click to expand...
 
Back
Top