LinkBack URL
About LinkBacks
Hello All,
Please help me with the formula or code to converts number(s) from custom format to number format:
8
10.0
1.1
4.10
12.5
82.10
126.8
245.11
Regards,
tt3
Hello All,
Please help me with the formula or code to converts number(s) from custom format to number format:
8
10.0
1.1
4.10
12.5
82.10
126.8
245.11
Regards,
tt3
What do you mean by Custom Format to Number Format?Originally Posted by tuongtu3
Please make your query clear for my better understanding
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
HiSixthsense
Please see attached and keep the same decimal places (because my code did not recognized "custom" format)
(The custom format from converting PDF to excel)
Regards,
tt3
Last edited by tuongtu3; 01-12-2015 at 03:58 AM.
Thanks for the screenshot but still I am puzzled about what is your actual requirement
Can you please attach a sample workbook with expected result?
Hi Sixthsense,
Please see attached and keep the same decimal places (because my code did not recognized "custom" format)
(The custom format from converting PDF to excel)
Regards,
tt3
Why don't you simply press Ctrl+A to select all cells and apply the desired Number formatting?
Or
Still am I missing your point?
Hi,
It does not work because how do I keep the same decimal after converting to number
1.8 ===> 1.8
2.11 ===> 2.11
Regards,
tt3
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks