How do I place a simple.

Thuntdon

New member
Joined
Sep 9, 2014
Messages
2
Reaction score
0
Points
0
I need to place a "-" or a "+" sign in a cell, so that when I save as a CSV file it will still be the same. What happens (even if cell formatted in text) is I get a cell location as if I want to start a formula calulation . The saved CSV shows a -0 for the - sign and a 0 for the +! How can I set up the cell (column) so that I get what I put in it?
Thanks for any help, Don

Note: I tried to do a proper search for this problem, but was hamstrung by not knowing how to form my search.
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
precede the - or + with an apostrophe (').

e.g. '- or '+
 
Top