Adding quotes around number

[ashish104]

I am new to excel. I have this number - 1111 in lets say cell A1 and i want to add double quotes around it. So the final result should be "1111". thanks for your help, oh i use excel 2010

 

[Luke M]

You do know that by adding quotes around it, XL will no longer treat it as number?

If that's really want you want, you can do:

=""""&A1&""""

 

[Hui]

Ashish104


Firstly, Welcome to the Chandoo.org forums.


You can also use a Custom Number format so that Excel will still recognise the Number as a Number

Select the cell

Ctrl 1

Goto the Custom Category and use the Format Code: "0"

If you will have negatives use: "0";"-0"

 

[droopy]

[Edit]

That comment is related to Luke's post, not to Hui's

[Edit]

That works if ashish uses a new range of cells to harvest the quoted values.

But what if he wants to modify the contents of the current numeric cells to quote them?


As far as I know, Excel does not offer regular expressions' find and replace.

An option could be:

[list type=decimal]
[*]Use a new range of cells as a temporary container,
[*]apply Luke's formula,
Copy that range
paste special it (values only, not formulas) to the initial range.
[/list type=decimal]