Posted to microsoft.public.excel.misc

hds[_2_]

external usenet poster

Posts: 1

Remove preceding zeroes?

I want to enter a value as .050 x 27.5 in a cell. I can due this by
formatting the cell as text, but when I copy to a new cell I get 0.050 x
27.5. Formatting the new cell has no effect on the leading zero.
Thanks

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
I need to remove the zeroes in a chart	ak_edm	Excel Discussion (Misc queries)	2	June 11th 09 08:19 PM
remove preceding zeros	Bruce	Excel Worksheet Functions	2	July 27th 07 02:52 PM
how do i remove zeroes values from exel sheet	Ana	New Users to Excel	10	June 14th 07 06:24 PM
Why do the preceding zeros disappear when I remove dashes?	carridin1	Excel Discussion (Misc queries)	3	June 5th 07 11:19 PM
Preceding Zeros...	Brian	Excel Worksheet Functions	2	December 14th 04 03:29 PM

All times are GMT +1. The time now is 09:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us