Hi. I'm trying to convert a range (a1:a12 in the sample) to a number format, but the code below does nothing.
Know this tiny green sign appears on a cell when there is an error? It suggested me to convert the cell to a number, but when I tried to record this move in order to check its code, it produced basicallty an empty code.. weird, isn't it?
Please Login or Register to view this content.
Last edited by GIS2013; 02-26-2014 at 08:40 AM. Reason: typo
Please * if you like the answer
It appears that your cells are full of leading spaces, so perhaps use the Trim formula and paste values and they should be numbers. Or even Find(" ") and Replace ("").
Thanks Stephen. I'll do it if there is no other way, the numberformat option looks so easy but it just doesn't work
Effectively it's text so formatting it as a number won't make any difference.
Using your spreadsheet example:
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
but if I accept the auto-correction tool's suggestion to "convert to number" suddently (see my code below) the MAX function works..
@alansidman, thanks it works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks