mike scott wrote: > On 9 Jul 2008 at 14:29, [EMAIL PROTECTED] wrote: > > .... > >> I have a case where numbers are used in a text format of xxxxxxxxxx (10 >> characters), that should be converted to xxx.xxx.xxxx (10 characters in >> groups of 3, 3 and 4 separated by a dot) >> >> The characters should be text, but using numbers; e.g. 001.002.0003 as a >> part number for a machine. >> >> In an exported CSV file there is a number of e.g. 0010020003 without the >> dots. The export was from a database that could not accommodate the >> numbers with the dots, because the fields were limited to 10 characters. >> I now need to format the cells as text (for CSV) with dots added, to >> import into a new database. >> >> When I use @###.###.#### it just adds ###.###.#### behind the number, >> e.g.: 0010020003###.###.####. I have tried various work-around's with >> numbers to text etc. >> What I need is to convert 0010020003 to 001.002.0003 as text. >> >> Any help appreciated. >> > > Try > > 000\.000\.0000 > > for the cell format, and make sure the csv file is saved as > displayed. > > > > Hi Mike,
Aha, thanx. That works when there is no leading zero. I forgot to mention there are also leading zeros. 1060582870 becomes 106.058.2870 0440221701 becomes 0440221701 Actually in the cell it is '0440221701. If I remove the ' in front of the text '0440221701, it formats correctly when it is a number with 1 leading zero. How can I remove all the leading ' tags for text in the leading zero cells? Find-Replace does not work, even for Regular Expressions. Al
