Hi khank,
Have you tried these two tricks?
If your data is in A1 then in A2 put the following formulas.
1. To force a number to text do a = A1 & ""
2. To force text to numers do a = A1 + 0
What happens to your display of data?
Did that help?
Hi khank,
Have you tried these two tricks?
If your data is in A1 then in A2 put the following formulas.
1. To force a number to text do a = A1 & ""
2. To force text to numers do a = A1 + 0
What happens to your display of data?
Did that help?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks