help, when I enter 0.5, it changes to 00.05, even if I enter 0.05 the result is still 00.05.
I'm using 2019 version
help, when I enter 0.5, it changes to 00.05, even if I enter 0.05 the result is still 00.05.
I'm using 2019 version
Last edited by FDibbins; 09-13-2021 at 12:51 AM. Reason: edited thread title
Hi, welcome to the forum
Pretty much everybody comes here for help, and we require that your thread title state what your problem is...HELP hardly does that, now does it?
I will change it for you -this time - but in future, please give more thought to your thread title.
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
what are the cells formatted as? or format the cells as number, does this make any difference? An attachment of the spreadsheet as per the yellow banner would make it easier for you to get a proper answer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks