This works for me...811294.12344 12344
811294.12346 12346
811294.12348 12348
811294.12350 1235
811294.12352 12352
811294.12354 12354
811294.12356 12356
811294.12358 12358
2711294.12457 12457
here is sample of what i am getting
Book1 | ||||
---|---|---|---|---|
A | B | |||
2 | 811294.12344 | 12344 | ||
3 | 811294.12346 | 12346 | ||
4 | 811294.12348 | 12348 | ||
5 | 811294.12350 | 12350 | ||
6 | 811294.12352 | 12352 | ||
7 | 811294.12354 | 12354 | ||
8 | 811294.12356 | 12356 | ||
9 | 811294.12358 | 12358 | ||
10 | 2711294.12457 | 12457 | ||
Sheet1 |
Did you see the formulas I posted in Message #14? If you try them, you will see that what you said is not the case for my formulas....so long as they remain as numbers it will treat 12345.67890 as 12345.6789 and appear to drop the final zero no matter what you do