View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Alan F
 
Posts: n/a
Default Deleting a $ sign in Excel

Thonks-that worked for me.

"Ron Coderre" wrote:

It sounds like the cells are formatted as Currency.

Try this:

Select the cells to be impacted.
From the Excel main menu:
<format<cells<number tab
Category: Select "General" or "Number"
Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Alan F" wrote:

How do I delete a $ sign next to a number in Excel. Seems the $ sign is
embedded in the cell even if I back space.