I am inputing serial numbers from cell phones onto an excel spreadsheet. But everytime I scan the number it round to the nearest thousandth.
This is an example of the number I need:
270113178503023059
But it keeps changing it to this:
270113178503023000
I've checked the number format and its on "number". I've tried even changing it to currency but it does the same thing.
Hi there!!
I am sure I am missing something stupid....but whenever I enter this number : "1202060000028309", Excel rounds off automatically. Why??? Can someone please explain?
Thanks,
Vikas
when I put a number is like 4031155000042041 excel changes the last number to 40. I do not want it to do that. How do I stop it. Please help.
I would like to be able to shut off the rounding function in excel. For
example: the number $1,428.627 I would like to have show up as $1,428.62.
Any help would be appreciated. Thank you.
I regularly paste long numbers into Excel, but I've seen it automatically round numbers.
In a new sheet, if I set the cell format to be a Number, with zero decimal places and then paste "4052450000000113" into the cell from the clipboard, the number appears as "405245000000011 0 ", so it rounds it down!
Any ideas please? Is this some kind of precision setting in Excel?
Thanks,
Rob
I have cell ranges that holds % data. the % is formatted to 0 decimal places so shows (for example) 47% when it is actually 47.021111
I need to have a simple equaltion that looks at automated rounding up to the nearest %. A whole number in other words!
Is there a formula to simply say .. Take A1, condense to nearest % and place in B1?
If that formula exists then prorblem solved, I will just insert a new column and hide it afterwards!
Thanks
I want to create a function which defines a pulse wave that rises from
0 to 1, stays at one for a bit, lowers to 0, and stays at zero for a
bit.
/ if (t mod 1) <0.25, V(t) = 4* (t mod 1)
| if 0.5 >= (t mod 1) > 0.25, V(t) = 1
V(t) = |
| if 0.75> =(t mod 1) > 0.5, V(t) = 1-4* (0.75-(t mod 1))
\ if 1 > (t mod 1) > 0.75, V(t) = 0
For this pulse wave there are straight rises, falls and flat bottoms
and tops, which I need (and which is why a sine wave can't be used). If
you're still with me, thanks.
I can either put this all into a long excel equation for each cell that
I want this in (there will be about 4 'if' statements and 6 'mod'
statements) or create a UDF, where the t mod 1 only has to be
calculated once.
Any idea out there how much faster/ slower as UDF really is in a case
like this? Also, can you think of an easier way to create this pulse
wave?
As a side note, the t in my program has some ROW() and COLUMN()
dependence, and there will be 200+ cells filled with this equation
(thus, I can't just compute it once and copy the values to each cell).
Caculation speed is important because each cell is being calculated as
the time, t, is advanced by a timer.
Thanks in advance to anyone who takes a stab at this.
-Abe
I need a formula that does this. I have a base number of 300 seconds and want to add 30 seconds to it for every number over 1 so the output would be like this
input 0 and get 0 out
input 1 and get 300 out
input 2 and get 330 out
input 3 and get 360 out
input 4 and get 390 out
and so on. I can't for the life of me get the math down. Can someone please help.
Hello again,
How would one do this?
Rounding to nearest HIGHER 4.95 or 9.95
Sample numbers below Desired Output
23.87 --------------------24.95
25 --------------------29.95
65.01 --------------------69.95
4.96 --------------------9.95
Rounding to nearest 1.99 above.
Sample numbers below Desired Output
0.76 ----------------------1.95
2.34 ----------------------3.95
22.64 ----------------------23.95
103.6 ---------------------104.95
Sample Rounding up.xlsx
Thanks again if you are able to help.
Jeff
