how do I format a cell to always have an ' in it?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to set up a spreadsheet for data entry, the entry will always be
numbers but I want the numbers to start with an '. Would like to set it up so
that it appears automatic. The ' does not need to show it just needs to be
there for uploading purposes. When we type them in by hand they dissapear
when we download them and we end up having to put them back in manually.
 
Penni,
Format/Cells/Text
The single apostrophe tells excel its really text and not a number, and if
you simply format the cells as text, you don't need the apostrophe.

HTH
Beege
 
Or you could Format/Cells/Custom and use '@ as your custom cell format...

beege
 
format as custom

"'"#,##0

Note: the cell value is 123 away it appears '123

hth
regards from Brazil
Marcelo

"Penni Lee" escreveu:
 
One more, just hit the apostrophe button twice before data input.

HTH
Martin
 
Any way to do this and not have the ' show?

Marcelo said:
format as custom

"'"#,##0

Note: the cell value is 123 away it appears '123

hth
regards from Brazil
Marcelo

"Penni Lee" escreveu:
Click to expand...
 
Hi Penni,

just typing but it will be text

hth
regards from Brazil

"Penni Lee" escreveu:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Export Gmail Emails to PST Format? 6
HDMI is a terrible format and I wish it never existed 2
Cell format 3
How do I copying data from a cell on sheet to a diff cell/sheet 1
Excel Typed text appears in wrong cell 0
How do I add an apostrophy to a range of existing cells? 3
Conditional Formatting - to highlight overwritten formulas 13
How do I format cells in Excel to make 175/5 read 175? 2

Back
Top