|
Not logged in [Login - Register] |
You Are Not Registered Or Not Logged In |
Corsa Sport » Message Board » Off Day » Geek Day » excel auto changing my numbers!? » Post Reply
|
sc0ott |
posted on 11th May 11 at 12:24 |
Or click on the box > right click > format cell > number > fraction. | |
Jas |
posted on 11th May 11 at 12:06 |
thanks allan | |
Robbo |
posted on 11th May 11 at 11:41 |
quote:ah yes, that's right | |
Brett |
posted on 11th May 11 at 11:32 |
Well, it applies for him also :0 | |
_Allan_ |
posted on 11th May 11 at 11:32 |
OMG OMG | |
Sam |
posted on 11th May 11 at 11:31 |
quote: I had to read your post twice Brett, I thought you wrote "Allah"... :o :lol: | |
ed |
posted on 11th May 11 at 11:30 |
Can't you up the precision in Excel somehow? Is it not in cell properties? | |
Brett |
posted on 11th May 11 at 11:29 |
Allan wins | |
_Allan_ |
posted on 11th May 11 at 11:27 |
put a ' in before each number. | |
Brett |
posted on 11th May 11 at 11:13 |
Should be fine as long as you format the cell as text before you type in the number? Won't work right if you format it afterwards. | |
Robbo |
posted on 11th May 11 at 11:05 |
try typing it in one cell then in the next do =value or =abs and link to it, that might work | |
Robbo |
posted on 11th May 11 at 11:05 |
hmm, i used to hve this issue when compilign spreadhseets with tens of thousands of sim numbers on too. ill try and recall what i had to do to correct it | |
Jas |
posted on 11th May 11 at 10:55 |
when I try enter say the following.... |