Deleting a $ sign in Excel

[Alan F]

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.

[KellTainer]

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?

[Ardus Petus]

Try Format>cell>Number>General

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

[Ron Coderre]

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.

[Alan F]

Thanks for the help. That worked for me.

"Ardus Petus" wrote:

> Try Format>cell>Number>General
>
> Cheers,
> --
> AP
> "Alan F" <Alan [email protected]> a écrit dans le message de news:
> [email protected]...
> > 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.
>
>
>

[Alan F]

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.