I have a cell which is the result of adding cells, the result should be 33 and it is showing 41701.
I have the cell on General format.
Thank you
I have a cell which is the result of adding cells, the result should be 33 and it is showing 41701.
I have the cell on General format.
Thank you
almost inmpossible to say without seeing what you are working with, but the value 41701 looks like a date value (3/3/2014)
Can you provide a sample workbook please?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
...yes I suspect it's not a coincidence that jatolo is expecting a number containing two 3s and is finding a date containing those two numbers.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
haha good catch Richard, I did not notice that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks