Can you give me an example.On 2002-04-09 04:06, SamS wrote:
Wherever you have numbers imported as text add 1 to it to convert it eg =A1+0 will do the trick where A1 is the cell that has come in as text.
Great,its works with adding 0 to the formuleOn 2002-04-09 04:34, sam_d1 wrote:
I am not sure why you want to convert the number (in text form) to number form.
If it is for using the number in calculations, It can be done without converting.
On 2002-04-09 04:10, verluc wrote:
Can you give me an example.On 2002-04-09 04:06, SamS wrote:
Wherever you have numbers imported as text add 1 to it to convert it eg =A1+0 will do the trick where A1 is the cell that has come in as text.
I have for instance 12 in Cell A10 as text
I have to turn it in 12 as number.
Many thanks