About Us

Julie,
Thank you so much for your help.
I DID IT. :-)

"JulieD" wrote:

Hi Tammy

choose custom, on the right you have a white line and a box (generally has
the word "general" in it).. in the white line delete whatever's there and
just type
"**"@

Cheers
JulieD

"Tammy Singer" <Tammy wrote in message
...
Thanks Julie,

I don't see where under general you can change the white line to put in **
as a prefix. I see special and custom but they are pre determined
characters
and formulas. Is there a way to set up a prefix in custom?

Any additional help would be great.

Thanks.

"JulieD" wrote:

Hi Tammy

if you only need to change the way they look (ie you're not exporting
them
or using them in a function or anything) then this can be achieved by a
custom format
select the cells, choose format / cells, under the number tab choose
custom
you should see the word General in the white line on the right change it
to
read
"**"@

Cheers
JulieD

"Tammy Singer" <Tammy wrote in message
...
Is there a way to insert a standard character before each cell of a
predetermined column?

For example, the info in the field says C01. I need for it to say
**C01.
It would take me hours to manually put a ** in one thousand records in
the
column.

Any help would be great!
Thans.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
Challenging Charting	C TO	Charts and Charting in Excel	0	January 17th 05 06:57 PM
how can excel colour a cell when it has a specified character	Kev	Excel Discussion (Misc queries)	4	January 8th 05 05:47 PM
Excel document properties insert into a cell	Mark	Excel Discussion (Misc queries)	3	December 16th 04 02:05 PM
Can I insert digital signatures into an Excel cell?	DrewAtNucorUtah	Excel Discussion (Misc queries)	1	December 15th 04 06:00 PM

Menu

About Us