Gad SAADIA
asked on
Excel text function
Hello
I am looking for an Excel function that will change a "number" into a "text string"
12345 (number) will become '12345 (string)
111 (number one hundred and eleven) will become '111 (notice the ' before the 111)
Like if I wanted to add automatically a ' before the number
I hope anyone can understand my need
Thank you
I am looking for an Excel function that will change a "number" into a "text string"
12345 (number) will become '12345 (string)
111 (number one hundred and eleven) will become '111 (notice the ' before the 111)
Like if I wanted to add automatically a ' before the number
I hope anyone can understand my need
Thank you
Use the TEXT function. http://office.microsoft.com/en-gb/excel-help/three-ways-to-convert-numbers-to-text-HA001136619.aspx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you it is perfect