Pesky Decimals
Posted by Rick on August 16, 2001 10:10 AM
I was wondering if it was possible to add decimal points to prexisting numbers. Example:
make 123456=1234.56
Any help is apprieciated.
Posted by lenze on August 16, 2001 10:19 AM
In a blank cell somewher, enter .01 and copy it. Then select the cells you want to change and choose Paste Special, selecting the Multiply Option
Posted by Ian on August 16, 2001 10:21 AM
If you want the number just to look like it has 2 decimal places use custom format
0"."00
if you WANT it to be 2 places
in the next column put
=a1/100
format to two decimals
Posted by Joe Was on August 16, 2001 10:23 AM
If the number is the result of a calculation, re-formating the range for your decimal requirements will work, as Excel stores the full number not just what is displayed. If your number was entered without the decimal, reformat the range and add the remainder to a range the add the two cells. like: In A1 is 1234 and Y1 is 0.56, in Z1 put =A1+Y1 then set A1 =Z1 in A1 yiu will get 1234.56. JSW
Posted by Mark W. on August 16, 2001 10:26 AM
Ahh, WYSIWYDG..."What You See Is What You Don't Get" : )
Posted by Ian on August 16, 2001 11:01 AM
Re: Ahh, WYSIWYDG..."What You See Is What You Don't Get" AND WYSIWYG two for the price of 1...Bargin :)
Posted by Mark W. on August 16, 2001 11:24 AM
Can't have it both ways...
...either 1234.56+1 = 1235.56 or it doesn't...
and it doesn't if "1234.56" is really 123456.
Posted by rick on August 16, 2001 12:02 PM
Thank you so very much. This has plauged me for months. Now, problem solved. I don't care if it's incorrect, wrong, or whatever. It works and that's all I need. Thank you again.
rick
Posted by Ian on August 16, 2001 3:25 PM
What ARE you on about Mark..I can and I HAVE
it DOES if you use my answer 2, it may be for veiwing purposes only, hence suggestion no 1.
does this not clearly state that it will just look like it has.....
and does this not state that it will have??
