Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formatting Cell

Status
Not open for further replies.
icdastar

icdastar

Technical User
Joined
Nov 16, 2004
Messages
12
Location
US
Hi,

How do you format a cell to remove the "$" sign? Thanks! I know this is probably a very simple answer for most of you advanced people. Thanks!

 
Sort by date Sort by votes
You could try Format Cells fromt he main menu but if the $ sign is actually in the cell rather then a format you will need to remove if with a formula

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MattGreer
  • Locked
  • Question Question
Add a formula in a cell that refers to another cell... Not using 'Range' tho
Replies
8
Views
644
MattGreer
MattGreer
EliseFreedman
  • Locked
  • Question Question
Excel 2016 formatting problem
Replies
3
Views
390
strongm
strongm
MattGreer
  • Locked
  • Question Question
Recalculate Radio-Button-Selected VBA Functions When A Cell Is Updated
Replies
18
Views
1K
strongm
strongm
TenDollarTypo
  • Locked
  • Question Question
Merge every 9 Cells Loop
Replies
3
Views
530
TenDollarTypo
TenDollarTypo
remeng
  • Locked
  • Question Question
Excel Formula with Reference NAME and conditional formatting
Replies
1
Views
333
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top