-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
how to add a ' to a cell of numbers to stop it changing into a formula when saved as a csv file
- Thread starter Geo000
- Start date
HalfAce
MrExcel MVP
- Joined
- Apr 6, 2003
- Messages
- 9,456
Hi,
I suppose adding an apostrophe to the beginning of your formula cells would do what you're after but I think all you really need to do is convert the formulas to values.
Try highlighting (selecting) your entire range of formulas and press Ctrl + C. Then simply press F10 and then V.
This will copy those formulas and paste special them as values.
If you're really set on adding the apostrophes, I can think of a way to do it with vba, but I think copying & pasting as values might be better.
Hope it helps.
I suppose adding an apostrophe to the beginning of your formula cells would do what you're after but I think all you really need to do is convert the formulas to values.
Try highlighting (selecting) your entire range of formulas and press Ctrl + C. Then simply press F10 and then V.
This will copy those formulas and paste special them as values.
If you're really set on adding the apostrophes, I can think of a way to do it with vba, but I think copying & pasting as values might be better.
Hope it helps.
Upvote
0
