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 strongm 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
Nov 16, 2004
12
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
Add a formula in a cell that refers to another cell... Not using 'Range' tho 2
Replies
8
Views
112
MattGreer
MattGreer
EliseFreedman
  • Locked
  • Question
Excel 2016 formatting problem
Replies
3
Views
86
strongm
strongm
MattGreer
  • Locked
  • Question
Recalculate Radio-Button-Selected VBA Functions When A Cell Is Updated 2
Replies
18
Views
291
strongm
strongm
TenDollarTypo
  • Locked
  • Question
Merge every 9 Cells Loop
Replies
3
Views
112
TenDollarTypo
TenDollarTypo
remeng
  • Locked
  • Question
Excel Formula with Reference NAME and conditional formatting
Replies
1
Views
81
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top