Posted to microsoft.public.excel.programming

timtm[_2_] timtm[_2_] is offline

external usenet poster

Posts: 1

Reformatting a cell using VBA

That did it. I changed it a bit to do the entire column. Thanks
lot.

with range("J:K")
.NumberFormat = "0.00000000"
.value=.value
end wit

--
Message posted from http://www.ExcelForum.com

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
Reformatting	ILoveMyCorgi	Excel Discussion (Misc queries)	5	January 12th 10 06:42 AM
Help With Reformatting	Robert	Excel Discussion (Misc queries)	0	July 23rd 09 02:56 PM
reformatting dates	[email protected]	Excel Discussion (Misc queries)	6	July 12th 07 09:09 PM
Reformatting a column	Janna	Excel Discussion (Misc queries)	4	September 14th 06 03:41 AM
need help reformatting spreadsheet	Fatboymedic	Excel Discussion (Misc queries)	1	November 15th 05 04:50 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us