Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel text function

Posted on 2014-10-21
3
Medium Priority
?
137 Views
Last Modified: 2014-10-22
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
0
Comment
Question by:gadsad
3 Comments
 
LVL 70

Expert Comment

by:KCTS
ID: 40395877
0
 
LVL 15

Accepted Solution

by:
Haris Djulic earned 2000 total points
ID: 40395881
Use TEXT function under assumption that A1 has the number here is the formula to get to text

=+TEXT(A1;"0")
0
 

Author Closing Comment

by:gadsad
ID: 40396331
Thank you it is perfect
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question