Hi,
i have a really curious one here, usingwhere the H column is a column of date format, returns
Please Login or Register to view this content.in the cell and not a number, I was expecting an integer from 1 to 54. What am I doing wrong?Please Login or Register to view this content.
Kind regards
Rob
Check to make sure the cell is not formatted as "text"
Also check to make sure there is no space before the equal sign.
Try a "Text to Columns" and simply click on "Finish"
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
...is it just one cell that is showing the text of the formula rather than the resulting value?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks