How do you copy and past a formula without it changing? If I copy =sum(A32/30)and past it into the cell directly below it changes to +sum(A33/30) If I have a number of cells to past this in, its a pain changing each one back to A32.
Before I start, A very thoughtful THANK YOU to Ken Write for your help in translating numbers to text. It worked great.
my next problem is a little more involved. on sheet 1 I have a payroll spreadsheet that list the names, hours and tax break downs of all the employees. Most of the tax...
Can I get Excel to take a number from one cell and translate that number to another cell, but in text form? Example $100.25 = One Hundred Dollars and 25/100
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.