G Guest Dec 4, 2003 #1 I am trying to round a number to the nearest 1,000 place. For example 53,750 up to 54,000. Any help would be great.
I am trying to round a number to the nearest 1,000 place. For example 53,750 up to 54,000. Any help would be great.
V Van T. Dinh Dec 4, 2003 #2 ?CLng(53750/1000)*1000 54000 -- HTH Van T. Dinh MVP (Access) HiLo said: I am trying to round a number to the nearest 1,000 place. For example Click to expand... 53,750 up to 54,000. Any help would be great.
?CLng(53750/1000)*1000 54000 -- HTH Van T. Dinh MVP (Access) HiLo said: I am trying to round a number to the nearest 1,000 place. For example Click to expand... 53,750 up to 54,000. Any help would be great.
T Tim Ferguson Dec 5, 2003 #3 I am trying to round a number to the nearest 1,000 place. For example 53,750 up to 54,000. Any help would be great. Click to expand... = Int(SomeNumber/1000 + 0.5) * 1000 Hope that helps Tim F
I am trying to round a number to the nearest 1,000 place. For example 53,750 up to 54,000. Any help would be great. Click to expand... = Int(SomeNumber/1000 + 0.5) * 1000 Hope that helps Tim F
