Chit Chat
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
Not being funny yeah, how do I turn off all auto-formatting in the 2003 version of Excel? I'm trying to imput some number based data onto a spreadsheet and every time I try to imput something like "7/2", it auto formats it to "07-Feb". If I cant**this soon, I might shoot myself. Help will be very well received.
Show More
I've got same prob and not sorted it...thanks for posting!
you can set it as text but cant perform any calculations from it
i like to right click, format cell , go to custom , and type ##/## and enter
this keeps fractions as fractions and you can do calculations from them as well
i like to right click, format cell , go to custom , and type ##/## and enter
this keeps fractions as fractions and you can do calculations from them as well
Mr. Fish,
You are my hero. Seriously. Set up a website called "Mr. Fish Is God" and I will subscribe to it's newsletter. Thanks.
You are my hero. Seriously. Set up a website called "Mr. Fish Is God" and I will subscribe to it's newsletter. Thanks.
just be careful that's all i ask,, with the sort of knowledge i have given you it can be dangerous in the wrong hands
Mr. Fish! Now it is auto converting 6/4 to 3/2. Help!
there the same thing, redbait...just alter perception ;)
ah the old 6/4 to 3/2 and 4/6 to 2/3
It dosnt actually make any difference in reality the way it displays it for calcualtion purposes but if you want to tidy up your data then you could have a seperate column and put
if(2/3 OR 3/2 was in A1 for example) THEN in column B
=IF(A1=2/3,"4/6",IF(A1=3/2,"6/4",A1))
of course this makes the 4/6 and 6/4 text so calculations would have ot be taken from the priginal 2/3 and 3/2
It dosnt actually make any difference in reality the way it displays it for calcualtion purposes but if you want to tidy up your data then you could have a seperate column and put
if(2/3 OR 3/2 was in A1 for example) THEN in column B
=IF(A1=2/3,"4/6",IF(A1=3/2,"6/4",A1))
of course this makes the 4/6 and 6/4 text so calculations would have ot be taken from the priginal 2/3 and 3/2
Of course, but it just doesn't look right. Like 100/30 and 10/3...
ah the old 6/4 to 3/2 and 4/6 to 2/3
It dosnt actually make any difference in reality the way it displays it for calcualtion purposes but if you want to tidy up your data then you could have a seperate column and put
if(2/3 OR 3/2 was in A1 for example) THEN in column B
=IF(A1=2/3,"4/6",IF(A1=3/2,"6/4",A1))
of course this makes the 4/6 and 6/4 text so calculations would have ot be taken from the priginal 2/3 and 3/2
It dosnt actually make any difference in reality the way it displays it for calcualtion purposes but if you want to tidy up your data then you could have a seperate column and put
if(2/3 OR 3/2 was in A1 for example) THEN in column B
=IF(A1=2/3,"4/6",IF(A1=3/2,"6/4",A1))
of course this makes the 4/6 and 6/4 text so calculations would have ot be taken from the priginal 2/3 and 3/2
oops sorry posted twice,, my battery went out wasnt sure if it had posted
what data are you keeping then out of interest
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539