excel auto changing my numbers!? - Corsa Sport - for Vauxhall and Opel Corsa B, Corsa C and Corsa D

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!?

New Topic

New Poll

Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.

Jas

Member

Registered: 13th Oct 04
Location: Mid Wales
User status: Offline

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

Robbo

Member

Registered: 6th Aug 02
Location: London
User status: Offline

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

Robbo

Member

Registered: 6th Aug 02
Location: London
User status: Offline

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

Brett

Premium Member

Registered: 16th Dec 02
Location: Manchester
User status: Offline

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.

_Allan_

Member

Registered: 24th Mar 04
User status: Offline

11th May 11 at 11:27

put a ' in before each number.
It's a limitation within excel.

Brett

Premium Member

Registered: 16th Dec 02
Location: Manchester
User status: Offline

11th May 11 at 11:29

Allan wins

Member

Registered: 10th Sep 03
User status: Offline

11th May 11 at 11:30

Can't you up the precision in Excel somehow? Is it not in cell properties?

Sam

Moderator
Premium Member

Registered: 24th Dec 99
Location: West Midlands
User status: Offline

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

_Allan_

Member

Registered: 24th Mar 04
User status: Offline

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