corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » excel auto changing my numbers!? » Post Reply

Post Reply
Who Can Post? All users can post new topics and all users can reply.
Icon:
Formatting Mode:
Normal
Advanced
Help

Insert Bold text Insert Italicized text Insert Underlined text Insert Centered text Insert a Hyperlink Insert Email Hyperlink Insert an Image Insert Code Formatted text Insert Quoted text
Message:
HTML is Off
Smilies are On
BB Code is On
[img] Code is On
Post Options: Disable smileys?
Turn BBCode off?
Receive email notification of new replies?

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


you will save me so much time


Robbo

posted on 11th May 11 at 11:41

quote:
Originally posted by _Allan_
put a ' in before each number.
It's a limitation within excel.
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

I'd like to thank my Mum and Dad for bringing me into this world and making this possible. Bill Gates and Paul Allen for creating Microsoft. Mr Owens my old IT teacher who first taught me this trick back in college. Everyone on CS.

Thank you all :wave:


Sam

posted on 11th May 11 at 11:31

quote:
Originally posted by loafofbrett
Allan wins


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.
It's a limitation within excel.


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....



8944122250030679240


I get


8944122250030670000


I change it the cell to text format and it works fine most of the time, but sometimes it doesn't..

any way of turning this auto format shit off?


does my head in when you've got 20-30 to do