Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / May 2006

Tip: Looking for answers? Try searching our database.

Symbol in front of Text - Reg

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
fitzol - 10 May 2006 06:40 GMT
Date : 10th April 2006

From
Fitzol

Dear Gentlemen,

I have the following requirement.

I have some data in cell A1. In B1 I want a particular character or a
Symbol or an alphabet to appear in front of what I enter.

Suppose I need letter G and in B1 if I type lkhhj It should appear G
lkhhj.
A space between is preferred.

Also in some cases I need to insert a symbol ( in most times "Ø" -
which comes by typing Alt+0216. The same is used for denoting
Diameter.)

Please give Suggestions.

Thanking you
G.Karthi

Signature

fitzol

Ardus Petus - 10 May 2006 07:11 GMT
Format>Cell>Number
select Customized
enter: "Ø 0" (without quotes)

HTH
--
AP

> Date : 10th April 2006
>
[quoted text clipped - 20 lines]
> Thanking you
> G.Karthi
RagDyeR - 10 May 2006 16:34 GMT
You'll need to differentiate between numbers and text (they *don't*
cross-reference), and also *exactly* where to place the character:

Ø #;"G" @

OR

# Ø;@ "G"

Signature

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

Format>Cell>Number
select Customized
enter: "Ø 0" (without quotes)

HTH
--
AP

"fitzol" <fitzol.27kucy_1147239900.7888@excelforum-nospam.com> a écrit dans
le message de news: fitzol.27kucy_1147239900.7888@excelforum-nospam.com...

> Date : 10th April 2006
>
[quoted text clipped - 20 lines]
> Thanking you
> G.Karthi
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.