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. -- Permission for this mail to be processed by any third party in connection with marketing or advertising purposes is hereby explicitly denied. http://www.scottsonline.org.uk lists incoming sites blocked because of spam [EMAIL PROTECTED] Mike Scott, Harlow, Essex, England --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
