Posted to microsoft.public.excel.worksheet.functions

Smiley[_2_] Smiley[_2_] is offline

external usenet poster

Posts: 13

Formating a cell

Hi! I am working on a spreadsheet where I have 5 columns of time. I need to
reformat all 5 columns to be the same. My time reads for example, 11:55 -
12:45. I want to reformat the cell so that there is a space before and after
the hyphen. Is there a formula to help me with this? I really don't want to
have to go to each cell and add those spaces.

Please help!

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
Need help with formating cell	Bandit	Excel Discussion (Misc queries)	4	August 12th 11 06:16 PM
Cell Formating	Curt Hand	Excel Worksheet Functions	3	October 20th 06 04:17 PM
Cell to follow content AND/OR formating of another cell	0-0 Wai Wai ^-^	Excel Discussion (Misc queries)	1	September 8th 05 02:00 PM
cell formating	Pat DeStasio	Excel Worksheet Functions	2	April 9th 05 10:23 PM
Cell not formating	Mojoala	Excel Discussion (Misc queries)	2	January 17th 05 08:21 PM

All times are GMT +1. The time now is 04:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us