Deleting a $ sign in Excel
 

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.

Deleting a $ sign in Excel
 

Try FormatcellNumberGeneral

Cheers,
--
AP
"Alan F" <Alan a écrit dans le message de news:
...
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.

Deleting a $ sign in Excel
 

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.

Deleting a $ sign in Excel
 

Weird, it seems like the cell was custom formatted but then again the
dollar sign didnt disappear after you deleted the value inside. Try
looking at the custom formatting options if it was formatted weirdly?


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=548277

Deleting a $ sign in Excel
 

Thanks for the help. That worked for me.

"Ardus Petus" wrote:

Try FormatcellNumberGeneral

Cheers,
--
AP
"Alan F" <Alan a écrit dans le message de news:
...
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.

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.