A
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.
embedded in the cell even if I back space.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Ardus Petus
Try Format>cell>Number>General
Cheers,
Cheers,
R
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
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
K
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?
dollar sign didnt disappear after you deleted the value inside. Try
looking at the custom formatting options if it was formatted weirdly?
A
Alan F
Thanks for the help. That worked for me.
Ardus Petus said:Try Format>cell>Number>General
Cheers,
A
Alan F
Thonks-that worked for me.
Ron Coderre said: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 said: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.