View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ATanker62 ATanker62 is offline
external usenet poster
 
Posts: 6
Default Creating a macro to formatt data

Hello

I have a long colum of data in the following format xxxxx, I require the
data to have five zeros before the number.

Example 12345 must be changed to display as 0000012345