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

P

Penni Lee

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.
 
B

Beege

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
 
M

Marcelo

format as custom

"'"#,##0

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

hth
regards from Brazil
Marcelo

"Penni Lee" escreveu:
 
P

Penni Lee

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...
 
M

Marcelo

Hi Penni,

just typing but it will be text

hth
regards from Brazil

"Penni Lee" escreveu:
 
Top