View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Convert numbers to text string

I think you will find that your "number" is actually text, as there
are too many digits for Excel to recognise as a number.

Anyway, you can do this in a helper cell:

=A1&""

to convert it to text.

Hope this helps.

Pete

On May 22, 12:32*am, GARY wrote:
A1 has a 'General' Number format and it contains:
1062110181110621101811

What function should I use to convert the contents of A1 to a text
string and what is the syntax?