exp vg
asked on
Excel - leading hidden apostrophe to indicate text
In Excel - how can I create a formula that will attach a leading apostrophe in front of numeric values to transform it into all cells in the column into text.
I have tried
= " ' " & A1
without success.
Thank you.
I have tried
= " ' " & A1
without success.
Thank you.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The aim is to have the hidden apostrophe
Example - when the small green triangle appears in the corner left to indicate a drop down to convert text to numbers if needed.
Example - when the small green triangle appears in the corner left to indicate a drop down to convert text to numbers if needed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you everyone.
=A1&""
That will return a number stored as text. If you then copy and paste special as values it will still be a number stored as text, but it does not show a ' sign in the cell.
cheers, teylyn