View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KLock KLock is offline
external usenet poster
 
Posts: 16
Default String of Numbers

I have a list of numbers;
For example
23489
52356
23563

I want to change into this precise format = '23489','52356','23563'

However CONCATENATE function will not help because list of number can very
in length from one week to another.

Does anybody have an idea of how to create a tool in either excel or access
to give me that precise format no matter how long my list of numbers is?

Thanks for any help,