LinkBack URL
About LinkBacks
qwertyjjj 
The reason is if the comma is representing with the text data then it will appear in formula bar. It the comma is lying with the numbers then excel remove the comma and treat it as continuous number.
The reason is if the comma is representing with the text data then it will appear in formula bar. It the comma is lying with the numbers then excel remove the comma and treat it as continuous number.
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
So, I have to convert all the cells to text? Or do I have to add a ' in front of all the numbers?Originally Posted by :) Sixthsense :)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks