On Saturday April 21 2007 11:12 am, jaques aillagon wrote: > Hi, I have got a problem in formatting my numbers. > > I got some .xls documents and in it there are thousands of numbers, > written such as 45.2156468546. When I open the document with > office, they are not considered as numbers, I can do whatever I > want but it is not taken as numbers. > > The only way I found is to replace the . by a , but impossible > regarding the mass of work it would be. > > When I put "english(united kingdom)" for the format, there is a ' > before the number and then if I remove the ' the cell is taken as a > number. This solution is also impossible! > > I give you one of my documents and then if someone knows how to do, > let me know!! > > bye bye and thank you by advance!
Try this: Regular Expressions checked. Search for: . Replace with: & This came from NoOP. Dan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
