Posted to microsoft.public.excel.misc

wdjsxj

Posts: n/a

delete leading 0

you have 3 alternatives:
1) in b1 you put in the formula :=a1+0 then copy down
2) in b1 you put in the formula :=trim(a1) then copy down
3) in b1 you put in the formula :=value(a1) then copy down

wdjsxj

€œHal B€ç¼–å†™ï¼š

I have a download in Excel, but the numbers have leading zeros (e.g. 00796,
01234). How do I delete these?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Keeping leading 0's	CLR	Excel Discussion (Misc queries)	3	March 3rd 06 10:45 PM
Remove leading space	Karidre	Excel Worksheet Functions	4	October 24th 05 03:39 PM
Delete leading zeros	lunker55	Excel Discussion (Misc queries)	4	September 22nd 05 11:06 AM
how do I delete a worksheet from my workbook	DLee	New Users to Excel	2	August 15th 05 09:59 PM
Delete row depending on criteria	adw223	Excel Discussion (Misc queries)	1	June 30th 05 12:55 AM

All times are GMT +1. The time now is 09:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us