LinkBack URL
About LinkBacks
Hi all
I always thought if you put a ' before a number it will stop excel from calculating that into a formula.
But when i put the ' in front my formulas still include it?
What am i doing wrong!
Hi all
I always thought if you put a ' before a number it will stop excel from calculating that into a formula.
But when i put the ' in front my formulas still include it?
What am i doing wrong!
Last edited by Chris_newton; 10-06-2015 at 07:34 AM.
What you're doing wrong for a start is making us guess what the formula is.
What's the formula?
' just turns the cell into text.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Sorry its a basic formula, it looks up a figure in another spreadsheet then subtracts from various boxes
='xx:\xxx\[Production Hours Availability.xls]2-11-15'!$H$17-F80-F81-F82-F83-F84-F85
Putting an apostrophe in front of a number won't always stop Excel treating it as a number in calculations.
e.g. =A1+A2+A3 will give 9 if A1 is 4, A2 is '3 and A3 is 2
but =SUM(A1,A2,A3) (or =SUM(A1:A3) ) will give 6.
Basically, Excel is sometimes 'cleverer' than you want it to be...
Assuming it's the F80:F85 cells which sometimes contain apostrophe-led numbers, try this instead of your formula:
Formula:
Please Login or Register to view this content.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Thank you so so much that did the trick!Originally Posted by Aardigspook
Putting an apostrophe in front of a number won't always stop Excel treating it as a number in calculations.
e.g. =A1+A2+A3 will give 9 if A1 is 4, A2 is '3 and A3 is 2
but =SUM(A1,A2,A3) (or =SUM(A1:A3) ) will give 6.
Basically, Excel is sometimes 'cleverer' than you want it to be...
Assuming it's the F80:F85 cells which sometimes contain apostrophe-led numbers, try this instead of your formula:
Formula:Please Login or Register to view this content.
Much appreciated!
You're welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks