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.

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.

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.

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

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.

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.