Forum Discussion
Solved
MS Excel Cell Formatting.
Hi Everyone! Here I want to get the only number value from a cell,,, like as: I have a value in a cell which is exactly same as 5,930.00 which you can say this cell normally formatted as general and...
Try the following:
Select the Unit Price column.
Set the number format to General (or to Number or to Currency, if you prefer).
On the Data tab of the ribbon, click Text to Columns.
Without changing any settings, click Finish.
Does that help?
Try the following:
Select the Unit Price column.
Set the number format to General (or to Number or to Currency, if you prefer).
On the Data tab of the ribbon, click Text to Columns.
Without changing any settings, click Finish.
Does that help?
