Excel
in [64 Bits Windows]
|
From: Cheri on 8 Jun 2010 15:43 I have numbers with 4 leading zeros and want to drop 3 - i've tried custom 0##### but the numbers seem to be formatted so that they won't change. How can I drop those 3 leading zeros
From: Bobby Johnson on 8 Jun 2010 15:54 I would suggest posting in an Excel group where you will find more people dealing with the program. I don't know what catagory your question would fall into, but you can start in: microsoft.public.excel.worksheet.functions or microsoft.public.excel.templates This group for Operating System questions instead of the Application. On 2010-06-08 15:43, Cheri wrote: > I have numbers with 4 leading zeros and want to drop 3 - i've tried custom > 0##### but the numbers seem to be formatted so that they won't change. How > can I drop those 3 leading zeros
From: Carlos on 9 Jun 2010 09:31 Cheri, Here: http://peltiertech.com/Excel/NumberFormats.html you'll find detailed info about numerical formats in Excel. There's a specific paragraph titled "Leading and Trailing Zeros and Spaces" that will help you with your issue. Carlos "Cheri" wrote: > I have numbers with 4 leading zeros and want to drop 3 - i've tried custom > 0##### but the numbers seem to be formatted so that they won't change. How > can I drop those 3 leading zeros
|
Pages: 1 Prev: CommunityForumsNNTPServer Next: Fail to create IXSSO.Query object |