LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default Insert Leading Characters If String Is Only 7 Characters

I need to insert a leading zero. But, I only need it in the event that the
string is only 7 or fewer characters.

3032009 would become 03032009
12122008 would remain 12122008

Thank you!!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy string of characters BRB Excel Discussion (Misc queries) 4 August 27th 08 12:28 PM
summing characters in a string DMG Excel Worksheet Functions 4 December 20th 05 02:44 PM
select a string of characters Did Excel Worksheet Functions 7 August 17th 05 04:24 AM
get characters from a string in excel Joao Excel Worksheet Functions 2 June 8th 05 09:47 AM
Insert characters in a text string jamae918 Excel Worksheet Functions 1 March 28th 05 10:04 PM


All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"